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

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

    Allin

      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?