Status Indicator for No Baseline

[PeteK]

[Project Server 2007]

Has anyone experienced trouble with the No Baseline indicator "?" not
showing up on un-baselined projects. Once I baseline a project I can see the
indicator for 1_, 2_ or 3_ but not 4_.

Thanks,
PeteK

I'm using the following formula which is used in the MS demo for Project
Server 2007:

Schedule status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

and then Project Schedule status = [schedule status]

 

[Dale Howard [MVP]]

PeteK --

Yes, I also had problems. I believe the formula as written is flawed. Try
the following formula instead:

Switch([Baseline Finish]=ProjDateValue("NA"),"No Baseline",[Finish
Variance]/480>10,"10+ Days Late",[Finish Variance]/480>1,"1 to 10 Days
Late",[Finish Variance]/480<=1,"On Schedule")

This formula is much simpler and will work as desired. Also, please note
how to trap for the "NA" value in the Baseline Finish field using the
correct application of the ProjDateValue function. Hope this helps.

 

[PeteK]

Dale,

Thanks! That definitely works better.

PeteK

PeteK --

Yes, I also had problems. I believe the formula as written is flawed. Try
the following formula instead:

Switch([Baseline Finish]=ProjDateValue("NA"),"No Baseline",[Finish
Variance]/480>10,"10+ Days Late",[Finish Variance]/480>1,"1 to 10 Days
Late",[Finish Variance]/480<=1,"On Schedule")

This formula is much simpler and will work as desired. Also, please note
how to trap for the "NA" value in the Baseline Finish field using the
correct application of the ProjDateValue function. Hope this helps.

[Project Server 2007]

Has anyone experienced trouble with the No Baseline indicator "?" not
showing up on un-baselined projects. Once I baseline a project I can see
the
indicator for 1_, 2_ or 3_ but not 4_.

Thanks,
PeteK

I'm using the following formula which is used in the MS demo for Project
Server 2007:

Schedule status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

and then Project Schedule status = [schedule status]

 

[Dale Howard [MVP]]

PeteK --

You are more than welcome, my friend!

Dale,

Thanks! That definitely works better.

PeteK

PeteK --

Yes, I also had problems. I believe the formula as written is flawed.
Try
the following formula instead:

Switch([Baseline Finish]=ProjDateValue("NA"),"No Baseline",[Finish
Variance]/480>10,"10+ Days Late",[Finish Variance]/480>1,"1 to 10 Days
Late",[Finish Variance]/480<=1,"On Schedule")

This formula is much simpler and will work as desired. Also, please note
how to trap for the "NA" value in the Baseline Finish field using the
correct application of the ProjDateValue function. Hope this helps.

[Project Server 2007]

Has anyone experienced trouble with the No Baseline indicator "?" not
showing up on un-baselined projects. Once I baseline a project I can
see
the
indicator for 1_, 2_ or 3_ but not 4_.

Thanks,
PeteK

I'm using the following formula which is used in the MS demo for
Project
Server 2007:

Schedule status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_
On
Schedule")))

and then Project Schedule status = [schedule status]

 

[Diaa Hussein - I would be glad to help]

Hello Petek

just try to remove the ProjDateValue from the function make it like
this

Schedule status =
IIf([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+
Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days
Late","3_ On
Schedule")))

please feed me back incased it did not work