4 Replies Latest reply on Jul 24, 2013 12:49 PM by Aishwarya Balamukundan

    IF statement for percentages in Calculated field

    Aishwarya Balamukundan

      Hi there,

       

      I am trying to color code Y/Y percentages and I am facing some issues:

       

      Y/Y is a calculated field - number format being % and no decimal places.

      IF [Y/Y Actual]>= 1 THEN

        "Positive"

      ELSEIF [Y/Y Actual] < -1 THEN

        "Negative"

      ELSE

         "No Change"

      END

       

      I use this calculated filed for the color coding.

      Somehow this isn't working for me- in the sense that if its a -ve % it goes to negative  I tried including 'ELSEIF Y/Y =0', it did not work either.

       

      It would be great if anyone could help me out! I guess I am having a dumb moment

       

      Thanks in advance,

      Aishwarya