How to exclude certain peaks from the formula of a CF?
Hello everybody, i did the next simple CF. Peak, real, calculated, result search first, all sample types and peaks, missing peaks yes, all or nothing yes.
Corrected_area: %Adjusted area+LT(%Adjusted area, 0.05)*1*60009.
The formula works, the issue is that I want to exclude two known peaks from the formula so that it can report an %adjusted area below 0.05%. Additionally, I would also like to be able to sum all the peaks that meet the conditions in the formula. What do you suggest? Thanks.
Corrected_area: %Adjusted area+LT(%Adjusted area, 0.05)*1*60009.
The formula works, the issue is that I want to exclude two known peaks from the formula so that it can report an %adjusted area below 0.05%. Additionally, I would also like to be able to sum all the peaks that meet the conditions in the formula. What do you suggest? Thanks.
0
Best Answer

Oh ok. In that case you can create a peak, real cf with formula:
(LT(%Adjusted Area,0.05)*%Adjusted Area)*EQ(Name,"Peak1")EQ(Name,"Peak2")+NEQ(Name,"Peak1")NEQ(Name,"Peak2")*1*50000
Make sure all or nothing is ticked.0
Answers

To exclude the two peaks modify the formula:
(%Adjusted area+LT(%Adjusted area, 0.05)*1*60009)*((NEQ(Name,"Peak 1")NEQ(Name,"Peak 2"))
This will give a value of 0 for the two excluded peaks. To sum these, create a Result, Real CF:
SUM(Corrected_Area)0 
Perhaps I didn’t express myself clearly. What I want to do is to be able to report these two specific peaks if they have an %adjusted area below 0.05. I don't want to report them with 0 value. I’m not sure if this is possible in any way.0