Traffic Lights & Current Baseline

R

Rami

Hi

I have an interesting question.

I am writing a formula for a custom outline code that will display red or
Green based on my actual cost compared to the baseline cost.

But the question is, how can I point to the current baseline which can be
baseline 1 or 2 or 3 or....

I cannot access the current baseline. Does this mean I need to make a
traffic light for each baseline?

Please help me.

Thanks
 
M

Marc Soester

Hi Rami,

The way I handle this is that my current baseline is always "Baseline".
before I change my baseline in copy the baseline to baseline1 meaning that my
baseline and baseline1 are the same. Then I change the baseline to the new
value. The effect is that Baseline 1 is my first baseline and baseline is my
current baseline. When I have to change the baseline again, I simply save the
baseline now to baseline 2, meaning that my baseline 2 is my second baseline.
then I overwrite the Baseline again ( I am sure you get my point :)

This also means that you formular will only need to be drawn from the
Baseline, not from the other baselines 1 - 10, meaning that you current
formular should work just fine.

I hope this helps
 
Top