Ratio calculation

lczenith
lczenith
in Software Products
Hi all,

I traying to do a CF to calculate the ratio between STD (API = CCalRef1) and Internal STD (IS = CCalRef2). 

So I have de Ave_Area of STD and Ave_Area of IS.

S%.%..AVE(CCalRef1[Area])/AVE(CCalRef2[Area])

But the CF is not working.

Thanks.

Answers

  • Empower2019
    Empower2019
    Is there a CCalRef2 option in Empower? Im using Empower 3.7 which isnt the latest version so perhaps there is but Im not familiar with CCalRef2, only CCalRef1 and CCompRef1-3.
    Response is a built-in Empower field which divides area of API divided by area of whatever component is designated as the internal standard in your processing method. 
    Change your Custom Field formula to this, and make sure search order is set to Result Set Only, peak and sample type are All and have Summarize Custom Fields as the last line of your sample set. 

    S%.%..AVE(Response)

    Then when you process a sample set to generate a Result Set the answer will be in the result set. 
  • lczenith
    lczenith
    I am using Empower 3.7. as well. 

    I know how to do the calculation when I input the final concentration of the standards. But I want to perform all these calculations to avoid calculations outside Empower.

    I want to create something like this;

    S%.%..(CCalRef1[Area])/AVE(CCalRef2[Area])
    Where: CCalRef1 is the API AVE_Area and CCalRef2 is the IS AVE_Area.

  • Empower2019
    Empower2019
    There is no CCalRef2 in Empower 3.7 only CCalRef1 and CCompRef1-3
    If you use CCompRef1 as your API peak and CCompRef2 as your IS peak then the formula becomes:

    S%.%..AVE(CCompRef1[Area])/S%.%..AVE(CCompRef2[Area])
  • lczenith
    lczenith
    Yes, have just CCalRef1, I wrote wrong. Thanks for help.

Categories