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.

Can anyone help?

Thanks

 

[Marc Soester]

Hi,

You may want to try

IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline",IIf([Cost]/[Baseline
Cost]>1.2,"Overbudget by 20% or more",IIf([Cost]/[Baseline Cost]>1,"between>
0-20% Overbudget",IIf([Cost]/[Baseline Cost]=1,"on budget","under> budget"))))

Hope this helps

 

[Kevin Watson]

Marc,
I really appreciate you giving me the formula to use, I tried it and still
got "error" for the projects with no baseline.

The graphical indicator value is set to (equals no baseline white
circle) did I screw something up here?

Hi,

You may want to try

IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline",IIf([Cost]/[Baseline
Cost]>1.2,"Overbudget by 20% or more",IIf([Cost]/[Baseline Cost]>1,"between>
0-20% Overbudget",IIf([Cost]/[Baseline Cost]=1,"on budget","under> budget"))))

Hope this helps
--
Marc Soester
Program Manager &
Senior Product Specialist

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.

Can anyone help?

Thanks

 

[Kevin Watson]

Marc,

I found the problem I forgot to hit F9, THANKS!

Marc,
I really appreciate you giving me the formula to use, I tried it and still
got "error" for the projects with no baseline.

The graphical indicator value is set to (equals no baseline white
circle) did I screw something up here?

Hi,

You may want to try

IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline",IIf([Cost]/[Baseline
Cost]>1.2,"Overbudget by 20% or more",IIf([Cost]/[Baseline Cost]>1,"between>
0-20% Overbudget",IIf([Cost]/[Baseline Cost]=1,"on budget","under> budget"))))

Hope this helps
--
Marc Soester
Program Manager &
Senior Product Specialist

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.

Can anyone help?

Thanks