How to exclude certain peaks from the formula of a CF?

David2024
David2024
in Software Products
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.


Best Answer

  • Empower2019
    Empower2019
    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. 

Answers

  • Empower2019
    Empower2019
    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)
  • David2024
    David2024

    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.


Categories