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

# 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.

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

Mirjam

• ###### Re: Traffic lights settings

Solved as:

Segment 1      <0

Segment 2      0

Segment 3      0.001