Empower 3 Pro Custom Field processing
Posted: Fri Dec 28, 2018 4:15 pm
I am trying to perform a custom calculation in empower using the sample area of a peak and the standard area of the same peak.
For example: (U%..(CCompRef1[Area])/(S%..(CCompRef1[Area]-U%..(CCompRef1[Area]))
However I have multiple samples and standards that are compared (U1 to S1, U2 to S2, and so on) and I'm trying to make a universal calculation instead of writing out the calc for each label group.
I have tried to use the summarize custom fields (plain and incrementally) using the labels however unlike calibrate i can't type both labels into the label reference it only allows for one and no wildcards. Any help on getting this to work for multiple samples would be greatly appreciated.
PS
I have gone through several iterations of this calc in my attempts:
By label:
(U1..(CCompRef1[Area])/(S1..(CCompRef1[Area]-U1..(CCompRef1[Area]))
Wildcard %:
(U%..(CCompRef1[Area])/(S%..(CCompRef1[Area]-U%..(CCompRef1[Area]))
Wildcard ?:
(U?..(CCompRef1[Area])/(S?..(CCompRef1[Area]-U?..(CCompRef1[Area]))
No Sample label:
(CCompRef1[Area]/(S%..(CCompRef1[Area]-(CCompRef1[Area]))
and my sequence is and must remain as:
Blank
S1
S2
S3
Blank
U1
U2
U3
Again thank you
For example: (U%..(CCompRef1[Area])/(S%..(CCompRef1[Area]-U%..(CCompRef1[Area]))
However I have multiple samples and standards that are compared (U1 to S1, U2 to S2, and so on) and I'm trying to make a universal calculation instead of writing out the calc for each label group.
I have tried to use the summarize custom fields (plain and incrementally) using the labels however unlike calibrate i can't type both labels into the label reference it only allows for one and no wildcards. Any help on getting this to work for multiple samples would be greatly appreciated.
PS
I have gone through several iterations of this calc in my attempts:
By label:
(U1..(CCompRef1[Area])/(S1..(CCompRef1[Area]-U1..(CCompRef1[Area]))
Wildcard %:
(U%..(CCompRef1[Area])/(S%..(CCompRef1[Area]-U%..(CCompRef1[Area]))
Wildcard ?:
(U?..(CCompRef1[Area])/(S?..(CCompRef1[Area]-U?..(CCompRef1[Area]))
No Sample label:
(CCompRef1[Area]/(S%..(CCompRef1[Area]-(CCompRef1[Area]))
and my sequence is and must remain as:
Blank
S1
S2
S3
Blank
U1
U2
U3
Again thank you