Empower Enumerated custom field

[Ciscosharpo]

Hi All,

I have made an enumerated peak field, and set the 'Use As' column to 'field', in the translation table I have put the names of some other custom fields containing calculated values with (fc) on the end.
When viewing the results in a report I can see these values properly - which is great.

My question is why cant i use any of these values in a calculation?

Many thanks in advance if anybody can help.

[Ciscosharpo]

Managed to do a calculation within the translation table field, and it all displays lovely in the report, but now the summary functions wont work in that particular column - it will do min/max, but wont work out mean + rsd?

[EmpowerGuru]

in order to sum those results you would need to make a custom field that only returns zero or the values you want to sum. so if the enumerator returns "<LOQ" or the custom field sepecified. You need to make an addidtional custom field that returns zero instead of "<LOQ", then you can sum this, and use that value in other calculations. The use as field enumerator is great but you can't perform summary calcs on it.