3 Replies Latest reply on Aug 18, 2017 4:40 AM by anil saini

    if statement with the range of values in a dimension

    sowjanya kolluru

      Hi

       

      I'm trying to write a statement using a if statement like the below but it is throwing errors. can some one please advise.

       

      if [dimension] = "0.1 - 3.3" and [trend] < 0.2 then "Green" else "Red" end

       

      Can someone please advise what is the error in the above code it is not working.

       

      thanks