Empower Custom Calculation
I am looking for help with a custom calculation.
I am looking to use the mean area from one peak (API) from several injections then use this area in the calculation of different samples with a different peak (IMP). I am able to calculate the mean for the API but I then don’t seem to be able to use it in further calculations for IMP.
The calculation I am trying to create is:
% IMP = Area IMP peak in sample 1 / Mean area API in sample 2 * 0.5 * 0.2Current calculations in Empower:
Mean_API_Area_in_Ref = EQ(Name,”API”)*Ref.%..AVE(Area)
Area_IMP_peak_in_sample = EQ(Name,”IMP”)*Area
These both work. However when I try to do the final calculation (see below) I get 0 beside API and no other results.
% IMP = (EQ(Name,”IMP”))*(Mean_API_Area_in_Ref)/(Area_IMP_peak_in_sample)*(0.5)*(0.2)