Custom Field with 3 options

Options
mlespake
mlespake
in Software Products
I need to create a custom field to display 3 different results:
1. If Amount is >=0.05, report Amount
2. If Amount is <0.05, report Below Quantitation Limit
3. If Amount is blank/empty, report Not Detected

Here is what I have already that is working but I dont know how to add the 3rd part.

Peak, Real:
GTE(Amount,0.05)*Amount + LT(Amount,0.05)*-60008

This custom field does not need to be numeric, it could be text because it would not be used for any further calculations.

Best Answer

  • Empower2019
    Empower2019
    Answer ✓
    Options
    It may be the order the formula is in. Empower takes each argument in turn, so if you put the arguments in order of lowest to highest, Empower will return the appropriate translation. 
    Change the formula to:

    ENUM(EQ(REPLACE(Amount,0),0),LT(REPLACE(Amount,0),0.05)GTE(REPLACE(Amount,0),0.05)) then the translations become 0: Not Detected 1: Below Quantitation Limit 2: Amount (fc)

    Im sure that will work as the peak will either be not detected ( ie 0), or below 0.05, or GTE 0.05. It must be one of those options. The Missing Peak box must be ticked and if you only want this custom field for named peaks, change Peak Type to Knowns. 

Answers

  • Empower2019
    Empower2019
    Options
    Peak Enum type Custom field. Search Order Result Set First, peak and sample type: All. Use as: Field. Make sure Missing Peak is ticked. 
    Formula is:
    ENUM(GTE(REPLACE(Amount,0),0.05),LT(REPLACE(Amount,0),0.05),EQ(REPLACE(Amount,0),0)). 
    You get 3 options in the Translation table, 0,1 and 2. For 0 type in Amount (fc). For 1 Type in Below Quantitation Limit and for 2 Type in Not Detected. process a chromatogram and this will work. 

  • mlespake
    mlespake
    Options
    Thank you for the info. First and second part works but the third part isn't. I am getting "Below Quantitation Limit" for any peak that is below 0.05 and also for named peaks that the Amount field is blank/empty/not found. 
  • blr81
    blr81
    Options
    EQ(Replace(Amount,0),0)* -60000 + GTE(Amount,0.05)*Amount + LT(Amount,0.05)*-60008. ALso select missing peak in custom field wizard
  • blr81
    blr81
    Options
    Without Enum also we can fulfill the requirement.

Categories