# Export samples from an average

I need to export the average of the 4 amounts. For example, I have this Sample Set table:

SampleName    Injections    Dilution

A                   1               10
A                   1               10
A                   1                 6
A                   1                 6
B                   1               10
B                   1               10
B                   1                 6
B                   1                 6

I have 4 results per each sample (2 injections/dilution). In my report I can calculate the average, but I would like to export that only result (the average). I don't have any labels assigned for them and I think I should, is that right? I don't know how many CF should I create or how to do it.

• Assign a Label of A for the 4 A samples and then Assign a Label of B for the 4 B Samples, and make sure A and B arent labelled anywhere else in the sample set. Create a peak, real custom field with search order Result Set Only and formula:
SAME.%..AVE(Amount) and make sure to put Summarize Custom Fields as the last line in the sample set.
When you process the sample set to generate a result set, the result for the average amount of each set of samples will populate in the result set. The "SAME" part of the formula basically tells Empower to average all the amounts for samples with the same label so as long as the labels for each set of samples you want averaged are all the same, it will work. It doesnt have to be A..B etc it can be U1 for unknown 1, U2, U3 etc.
If you only want one particular peak averaged then you can set that peak in CCalRef1 of the processing method used to process the sample set, in which case the formula changes to:
SAME.%..AVE(CCalRef1[Amount])