Getting "Error" on Budget field

[kwwatson]

I am using the following formula for a budget stoplight indicator.


Switch([Baseline Start]>#12/31/2049#,"No baseline",[Cost]/[Baseline
Cost]>1.2,"Overbudget by 20% or more",[Cost]/[Baseline Cost]>1,"between

0-20% Overbudget",[Cost]/[Baseline Cost]=1,"on budget",True,"under
budget")


My graphical indicator is set to


equals No Baseline white circle


But after doing the calculation and republishing I get "error" where a
white circle should be. I have also tried using 999999 instead of
#12/31/2049# but I get the same result.


How do I fix this?


Thanks

 

[Gary L. Chefetz [MVP]]

Kevin:

I'll answer in the other post