How to do a GENERAL CF to calculate the average between two injctions?

lczenith
lczenith
in Software Products
Hi all, 

How to do a GENERAL CF to calculate the average between two injections.
For example, I have a file "Sample_Conc" and I want to a general CF to calculate the average of the CF "Sample_Conc". 

Injection 1 and 2: Label: UK1 = UK.%.SAME.AVE(Sample_Conc) (could be like this CF?)

Than the same CF to calculate the AVE for other two sample injections.

Injection 1 and 2: Label: UK2
Injection 1 and 2: Label: UK3
Injection 1 and 2: Label: UK4...


Thanks.

Answers

  • Empower2019
    Empower2019
    edited April 30
    You dont need to specify the label in the custom field formula, since you have more than 1 injection per sample. I would just change the formula to:

    SAME.%.SAME.AVE(Sample_Conc), and set the search order to Result Set Only and add Summarize Custom Fields as the last line in the sample set- ensure to process a sample set to generate a result set to get your answer. Empower will calculate the result for each unique label. 

    Note: make sure each sample has a unique label for this to work. 
  • lczenith
    lczenith
    Hi, thanks a lot, but the CF just work with "search order to Result Set First". After that I have a problem (Figure 1). In the report, all results appear, with the corrected ones highlighted in yellow because their calculation uses the average concentration. Do you have any idea how can I prevent the blue results (Figure 2) from appearing? Thanks.
     


Categories