How to calculate the maximum Impurity response for unnamed impurity

EmilyKim
EmilyKim
edited November 7 in Software Products

I want to find the maximum impurity response excluding a specified impurity.
In the report, I can only find the maximum impurity response for all impurities.

So,  I create a CF with the formula,

IM%.%..MAX(Impurity Response)*NEQ(Component Type,"Specified impurity")

but it doesn't work. 

how can i get the result ?

Answers

  • Jovvor
    Jovvor
    If it is an unknown impurity you could easily let it calculate only for unknown samples and only unknown peaks.
    That way a specified impurity (where i presume a name is written for) will not be taken into account.

    And than create your custom field without the NEQ state behind it.
    Probably because it is looking at your formula at the maximum response and than looks if it is a specified impurity it will result in searching the maximum response and multiplying it by 0 because it is a specified impurity.
    That custom field will give 0 as a result than.

    Or you should make different custom fields and break the formula up.
    One where you see if it is specified impurity or not, one that multiplies the imp response and the boolean, and one that than searches within that multiplication after your maximum impurity.

    Hope that clarifies some things.

Categories