Help with Budget Formula "Stoplights"

[kevin.watson3]

The following formula works well except for not being able to recognize
when there is no baseline. Currently this shows up with a value of 30
with according to the graphical indicators is red. Can someone please
modify the formula to include a condition to flag for no baseline? I
want to show a white circle when there is no baseline.

Thanks


IIf([Cost]<>0,IIf([Cost]<[Baseline Cost]*1.2,IIf([Cost]<[Baseline
Cost]*1.1,10,20),30),0)

 

[Dale Howard [MVP]]

Kevin --

One way to "trap" the error caused by not baselining the project (or task)
is to use the following:

IIF([Baseline Start]>65000,truevalue,falsevalue)

Hope this helps.