1 Reply Latest reply: Aug 22, 2013 4:11 AM by Mirjam Ribeiro de Oliveira RSS

    Traffic lights settings

      We use traffic lights in comparison with previous years, in the following case it is on the margin.
      Now I would like to see when the percentage margin is negative, the meter is red, when it is positive the meter is green, and when it is 0, the meter is gray.
      Now I've been working with the meter characteristics, but I fail to get the settings right.
      Because if I add Segment 3 (gray) with a lower limit of 0, and
      change the lower limit of Segment 2 (green) to 0.01, then he turns red in the table.

      See also attached files.
      Can someone help me with the correct settings? And is my formula correct?

       

      Margin Variance:

      If([Margin %
      $(vPriorYear)]
      =0,0,([Margin %
      $(vMaxYear)]
      - [Margin %
      $(vPriorYear)]
      ) / fabs([Margin %
      $(vPriorYear)]
      ))

      //If statement needed for situation vPriorYear = 0
      //fabs statement needed for situation vPriorYear negatief

      Thanks in advance!

      Mirjam