by
shaun78 » Thu Feb 27, 2014 1:52 pm
Pictures are worth a thousand words:
Make your sample set method look like what I have above.
Custom fields:
Code: Select all
SS1.%.%.AVE(Area)
SS2.%.%.AVE(Area)
You will need an SS#.%.%.AVE(Area) for as many SS# labels as you require in your sample set. I generally name these custom fields, SS1, SS2, etc. These are all peak, real (0.0), calculated type custom fields.
You will now need a custom field to calculate recoveries (peak, enum, calculated, used as field type custom field):
Code: Select all
ENUM((EQ(Label,"SS2")),(EQ(Label,"SS3")))
Translation Value
0 (SS2/SS1)*100 (fc)
1 (SS3/SS1)*100 (fc)
You will need as many translations and values as you have brackets. This will calculate standard recoveries for you, which you did not mention, but I assumed.
The setup of the sample set method handles the calculation of the samples using the desired standards.