#ERROR for Project Status

[Charles L. Simpson]

We are using the following formula to indicate a Project Status indicator on
PWA:

IIf([% Complete]=100,"Project Complete",IIf([Enterprise Project Text4]="On
Hold","Project is on Hold",IIf([Enterprise Project Text4]="Backlog","Project
is Backlogged",IIf(DateDiff("d",[Finish],[Baseline Finish])<=-7,"Project is
over 7 days Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<0,"Project is
Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<7,"Project is on
Schedule","Project is at least 7 Days Early"))))))

If there is no date in the Baseline Finish field, PWA displays "#ERROR"
using the above formula. How could I modify this formula so that if there
is no date in the Baseline Finish field, PWA would display "Project has not
been baselined"?

Thanks!
--
---------------------------------------------------------------
Charles L. Simpson
ACT, Inc.
---------------------------------------------------------------
Current Setup:
WSS 2.0 (no service packs)
Project Server 2003 SP1
SQL Server 2000 SP3a
FrontPage 2003 SP2
-----------------------------------------------------------------

 

[mark.everett]

Charles -

You want to add a baseline indicator like:
IIf([Baseline Finish]>#1/1/2900#,"No Baseline"

There are a number of ways to do the baseline, or lack thereof, but
this one works. I usually use a white circle to indicate No Baseline
and a blue circle to indicate that the baseline has been set.

Mark Everett | PMP
www.quantumpm.com

 

[Gérard Ducouret]

Charles,
Insert your formula in this one :

IIf([Baseline Finish]=2^32-1;"truepart";"falsepart")

Gérard Ducouret

 

[Charles L. Simpson]

Still no luck ... It sill shows #ERROR when you put your mouse over the
graphical indicator.

I know that they have this fixed in the next version ... I tought that
perhaps I could use a work-a-round until then.

Thanks

Charles L. Simpson

Charles,
Insert your formula in this one :

IIf([Baseline Finish]=2^32-1;"truepart";"falsepart")

Gérard Ducouret

"Charles L. Simpson" <[email protected]> a écrit dans le message
de

We are using the following formula to indicate a Project Status indicator on
PWA:

IIf([% Complete]=100,"Project Complete",IIf([Enterprise Project
Text4]="On
Hold","Project is on Hold",IIf([Enterprise Project Text4]="Backlog","Project
is Backlogged",IIf(DateDiff("d",[Finish],[Baseline Finish])<=-7,"Project is
over 7 days Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<0,"Project is
Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<7,"Project is on
Schedule","Project is at least 7 Days Early"))))))

If there is no date in the Baseline Finish field, PWA displays "#ERROR"
using the above formula. How could I modify this formula so that if
there
is no date in the Baseline Finish field, PWA would display "Project has not
been baselined"?

Thanks!
--
---------------------------------------------------------------
Charles L. Simpson
ACT, Inc.
---------------------------------------------------------------
Current Setup:
WSS 2.0 (no service packs)
Project Server 2003 SP1
SQL Server 2000 SP3a
FrontPage 2003 SP2

 

[mark.everett]

Charles -

I am assuming that you have baselined the plan, correct? Then it
should work. It works in plan I am looking at now.

Mark

 

[Charles L. Simpson]

Thanks Mark

I used the following and it finally worked!!!

EXISTING FORMULA:
IIf([% Complete]=100,"Project Complete",IIf([Enterprise Project Text4]="On
Hold","Project is on Hold",IIf([Enterprise Project Text4]="Backlog","Project
is Backlogged",IIf(DateDiff("d",[Finish],[Baseline Finish])<=-7,"Project is
over 7 days Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<0,"Project is
Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<7,"Project is on
Schedule","Project is at least 7 Days Early"))))))



NEW FORMULA:
IIf([% Complete]=100,"Project Complete",IIf([Enterprise Project Text4]="On
Hold","Project is on Hold",IIf([Enterprise Project Text4]="Backlog","Project
is Backlogged",IIf([Baseline Finish]>1/1/2037,"No
Baseline",IIf(DateDiff("d",[Finish],[Baseline Finish])<=-7,"Project is over
7 days Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<0,"Project is
Late",IIf(DateDiff("d",[Finish],[Baseline Finish])<7,"Project is on
Schedule","Project is at least 7 Days Early")))))))

Thanks to everyone for their help!!!

Charles L. Simpson