# Custom Field ENUM

Hi ,

How far can you push the ENUM CF with translation ?

I am currently using 0,1,2 for 'LOD', 'LOQ' then Amount (fc)

Do text strings -1*60008 (fc) work ?

Is it possible to carryout further calculations ie Amount*SampleWeight/Cconst 1 for example as a translation

0

## Answers

Hi ydan1977, as far as I know you can have multiple translations under the Use as Field and as long as your formula has (fc) at the end then it will translate, so position 0 could be Below LOD, 1 could be Below LOQ, 2 could be Amount (fc), 3 could be Amount*Sampleweight/CConst1 (fc). I'm not too sure that the text translations of -60008 etc will work because if you put down -60008 (fc) Empower will look for a field in Empower called "-60008" and it will crash out.

Another way to do this though is create a peak, real CF such as LT(Amount,0)*-60008+RANGE(Amount,CConst1,CConst2)*-60004+GT(Amount,CConst2)*Amount. Make sure All or Nothing is ticked for this to work. Or you could set up 2 peak, real CFs and for the formula just put in CConst1 and CConst2, Call these LOD and LOQ, then you can substitute these in your equation above, such that:

LT(Amount,LOD)*-60008+RANGE(Amount,LOD,LOQ)*-60004+GT(Amount,LOQ)*Amount

Thanks Empower2019

I also been playing with LT RANGE etc ,, just trying to way up pros and cons for rel subs reporting

I saw a document which stated translation as -1*5000 (fc) to contain no value so assumed other text strings would work. Like the use of LOD , LOQ and CConst1 , therefore vary LOQ limits if imps different spec wrt unknown /known peaks

Hi ,

Text strings do work if you set calc criteria use as 'field' although I cant seem to get -60006 or -60008 text string to work. Maybe something to do with length of text output been greater than width 15

also on the subject of ENUM , will this formula work as % agreement of samples :

(U0101.1.(Amount)-U0102.1.(Amount))/((U0101.1.(Amount)+U0102.1.(Amount))/2)*100 (fc)

Seems to work for % Area agreement but for amount only returning '200' (assuming 100/(100/2)).. or is it possible to do an ENUM of ENUM perhaps ?