Displaying Peak Type within a Bool/Enumerated custom field
I have a custom field that calculates % Impurity. My reporting limit is 0.5%. I'm trying to set up a custom field which, for values lower than this, displays "Below Reporting Limit" and for values equal to or greater than 0.5% displays the actual custom field results. That's fine I have that set up as follows: Peak Bool Calculated Use as Field and the formula is: GTE(Percent_Impurity,CConst7) with the translation table reading 0 = Below Reporting Limit and 1 = Percent_Impurity (fc).
The problem is I want to also display a "Not Detected" for peaks which are "Missing" so I tag on a "+EQ(Peak Type,"Missing")*-1*60002 at the end of the formula but when I process data it still shows blank for missing peaks, and I have the Missing checkbox ticked so that's not the issue. I tried an ENUM formula where one of the Bool conditions is "EQ(Peak Type, "Missing") with a corresponding translation in the translation table of -1*60002 (fc) but still nothing for missing peaks.
Is this because the data type is a field and you cant have two (fc) entries in the one table or is there another reason why I cant get this formula to display Not Detected for missing peaks?