AnsweredAssumed Answered

field value is same as function name, so can't calculate

Question asked by Allin on Feb 14, 2017
Latest reply on Feb 15, 2017 by coherentkris

I have a value list where one of the options is "Lower". I can't do any calculations using this value, because, I think, the value is being evaluated as a the function Lower.

 

Example:

 

Field1 = lower

Field2 = 10

 

Case ( Field1  = "lower" and Field2 > 0 ; 1; Field1 = "higher" and Field2 < 0 ; 1; 0 )

 

The result is still 0, the default.

 

Field1= higher

Field2 =  -10

The result is 1

 

Is there a way to mark lower as text or a field value so it is not evaluated as a function?

Outcomes