"Error" in stoplight indicator field for projects with no baselines

[kevin.watson3]

I am using the following stoplight indicator for budget variances
(straight out of the sample database).
I have set up the graphical indicators to match the same way it is in
the same database (equals - (value) - "No baseline" to a white circle.

The project center view shows "error" where ever there is no baseline.
I should see a white circle.

Any ideas as to what the problem is and how to fix it?

Switch(Len(CStr([Baseline Finish]))<3,"No
baseline",([Cost]+1)/([Baseline Cost]+1)>1.2,"Overbudget by 20% or
more",([Cost]+1)/([Baseline Cost]+1)>1,"Overbudget",True,"Under
budget")

Thank You

 

[Gary L. Chefetz [MVP]]

Kevin:

One should never assume that the samples Microsoft provides are tested and
working. You'll note the same error if you publish a non-baselined plan to
the sample database. The correct way, certainly not the only way, is to use
projdatevalue function to test for "NA" value, for example:

IIf([Baseline Finish]=projdatevalue("NA"),"No Baseline"

 

[kevin.watson3]

Gary,

It would be a big help if you were to disclose the full formula needed,
not just part of it. I tried taking your segment and make it work, but
formula's are not my thing and I could use your help. Thanks

 

[Gary L. Chefetz [MVP]]

Assuming the rest of the formula works

Switch([Baseline Finish]=projdatevalue("NA"),"No
Baseline",([Cost]+1)/([Baseline Cost]+1)>1.2,"Overbudget by 20% or
more",([Cost]+1)/([Baseline Cost]+1)>1,"Overbudget",True,"Under
budget")

 

[kevin.watson3]

Thank You! If you have any other examples of some that use more than
four condictions, I would to see them. They appear to be in rather
short supply from what I can see.

 

[Mike]

Kevin

It's generally a good idea to know the question before you give an
answer, however try this:

Schedule [ET1] – a schedule variance field which compares (at task
level) finish date with baseline finish date + tolerance and status
date, and generates a graphical indicator. Formula is:

IIf((([Baseline Start]=ProjDateValue("NA")) Or ([Baseline
Finish]=ProjDateValue("NA"))),â€No Baselineâ€,
IIf([Status]=0,â€Completeâ€,
IIf([Status]=2, “Not Updatedâ€,
IIf(([Finish]-[Baseline Finish])<=0,â€On Scheduleâ€,
IIf(([Finish]-ProjDateAdd([Baseline Finish],[Enterprise Project
Duration1]))<0,â€Within Toleranceâ€,
“Outside Toleranceâ€)))))

Note: Status field determines whether a task is completed)-1),
“late†(3), on schedule, or future task, based on task progress
relative to project status date. A “Late†task indicates plan not
correctly statussed and therefore a warning flag is displayed.
Tolerance is held EPD1

Graphical indicators are:
Value RAG
No Baseline â—White Circle
Not Updated Æ Red Flag
Outside Tolerance â—Red Circle
Within Tolerance â—Amber Circle
On Schedule â—Green Circle
Complete â—Blue Circle

regards

Mike