mikeloria

Using an Enumeration Set in a Formula data Reference

Discussion created by mikeloria on May 27, 2011
Latest reply on Nov 2, 2020 by Rick_Davin_3.0

I am having trouble seeing how an enumeration set can be used as the output of a data reference formula:

 

Say I have an enuration set such as

 

0 = OK

 

1 = low

 

2=high

 

Then I have a formula where A = value, B = lower limit, C = Upper Limit. I want to output the enumerated value so that if

 

A < B then low else if A > C the high else OK

 

I cannot seem to get this to work.

 

Thank you in adavnce for your responses.

Outcomes