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.
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.
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?