What will this formula return in Empower?
I have been asked to calculate the Average. Maximum and Minimum areas of my active but only across certain injections of the sample set. I know I could just filter by label and use the report method but im looking for a quicker result and I read that something like the following formula would assist:
Sample, Text, Keyboard custom field called “Custom_Ref”.
Then a peak, real, calculated custom field, set to Result Set Only which takes in all labels, injections, the same channels and only the Average (or Max, Min etc) Areas of samples where “custom_ref” is populated. Here is the formula:
So for the samples that I want to calculate Average Areas, I will populate that line in the sample set with “R1”, but the thing is im getting weird results when I process the run, figures which don’t make any sense at all and I don’t know where they are coming from, can anyone clarify what exactly the formula will return when Empower processes the run?. I have Summarize Custom Fields in the sample set, what affects this calculation, does the processing lines etc play a part? Or is this way too complicated?
I basically only want the average area of my active in sample lines where R1 is populated. So if R1 was set in Lines 3,5,6,10 and 50, I only want the average area of active for all those lines..