11 Replies Latest reply on Feb 15, 2017 6:40 AM by coherentkris

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


      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.


      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?