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


      ELSEIF [Y/Y Actual] < -1 THEN



         "No Change"



      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,