Empower Replace function

[ama1001]

I am trying to replace a null value for Amount with Not Detected. I did it in 2 steps:
REPLACE(amount,-9999)
ENUM( ........., EQ(amount,-9999)
In the translation table, "Not Detected" is the value of the enumerated custom field. However, when the peak is missing, amount does not get the value -9999 and the enumerated custom field does not equal, "Not Detected". I thought replace will assign a new value when the field equals Null.
What am I doing wrong?
Thanks,
AA

[shaun78]

There is a built in database code for "Not Detected" in Empower. That code is -60002.

If I had to code this, I would personally use:

EQ(Peak Type,"Missing")*-1*60002

In this field, if a named peak is not found, then the result is 1*-1*60002, or -60002 which the database will automatically translate as Not Detected. Use the appropriate REPLACE function to get that Not Detected into the cell you are after.

[ama1001]

Thanks. I will try that.