Formula for 'Project Schedule'

[Jim Puls]

I'm having difficulty using the Project Schedule enterprise project text
field provided in the Project Server sample database:

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5 days",ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",True,"On schedule")

It's odd, because I'm pretty sure it worked fine when Project Server 2003
was released, but now something seems to have changed! The system I'm
working with is up to date in patches and service packs, afaik. In
particular, when I have a project with no baseline, I get "#ERROR" rather
than "No baseline". A baselined project correctly produces "Late by more
than 5 days", "Late" or "On schedule".

My understanding is that with no baseline, [Baseline Finish] should be "NA",
which is two characters long, so Len(CStr([Baseline Finish])) should be 2.

I've also tried Gaurav Wason's ng formula IIf(CDbl([Baseline
Finish])>60000,"Not Baselined","Baselined")
which works ok stand alone, but when incorporated into a four way Switch,
also produces #ERROR.

Any suggestions?

Thanks,

Jim

 

[JackD]

I'm not sure if the CDbl is supported or required.
Two approaches which I have used successfully are:
[Baseline finish] > 50000
[Baseline Finish]=ProjDateValue("NA").

The latter is courtesy of Brian K.

 

[Tony]

We are having the same problem and the suggested:

[Baseline finish] > 50000
[Baseline Finish]=ProjDateValue("NA")

both do not seem to work in a four way switch.

Any other suggestions?

I'm not sure if the CDbl is supported or required.
Two approaches which I have used successfully are:
[Baseline finish] > 50000
[Baseline Finish]=ProjDateValue("NA").

The latter is courtesy of Brian K.
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

I'm having difficulty using the Project Schedule enterprise project text
field provided in the Project Server sample database:

Switch(Len(CStr([Baseline Finish]))<3,"No
baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5
days",ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",True,"On schedule")

It's odd, because I'm pretty sure it worked fine when Project Server 2003
was released, but now something seems to have changed! The system I'm
working with is up to date in patches and service packs, afaik. In
particular, when I have a project with no baseline, I get "#ERROR" rather
than "No baseline". A baselined project correctly produces "Late by more
than 5 days", "Late" or "On schedule".

My understanding is that with no baseline, [Baseline Finish] should be "NA",
which is two characters long, so Len(CStr([Baseline Finish])) should be
2.

I've also tried Gaurav Wason's ng formula IIf(CDbl([Baseline
Finish])>60000,"Not Baselined","Baselined")
which works ok stand alone, but when incorporated into a four way Switch,
also produces #ERROR.

Any suggestions?

Thanks,

Jim

 

[Gaurav Wason]

I know this is a very late reply and by now you would have already solved the
issue. Try to add a new task to project and save it. This will refresh the
project. Will will make Error to not baselined and then you can delete the
new task you just created.

I hope this is helpful

Gaurav Wason

We are having the same problem and the suggested:

[Baseline finish] > 50000
[Baseline Finish]=ProjDateValue("NA")

both do not seem to work in a four way switch.

Any other suggestions?

I'm not sure if the CDbl is supported or required.
Two approaches which I have used successfully are:
[Baseline finish] > 50000
[Baseline Finish]=ProjDateValue("NA").

The latter is courtesy of Brian K.
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

I'm having difficulty using the Project Schedule enterprise project text
field provided in the Project Server sample database:

Switch(Len(CStr([Baseline Finish]))<3,"No
baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5
days",ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",True,"On schedule")

It's odd, because I'm pretty sure it worked fine when Project Server 2003
was released, but now something seems to have changed! The system I'm
working with is up to date in patches and service packs, afaik. In
particular, when I have a project with no baseline, I get "#ERROR" rather
than "No baseline". A baselined project correctly produces "Late by more
than 5 days", "Late" or "On schedule".

My understanding is that with no baseline, [Baseline Finish] should be "NA",
which is two characters long, so Len(CStr([Baseline Finish])) should be
2.

I've also tried Gaurav Wason's ng formula IIf(CDbl([Baseline
Finish])>60000,"Not Baselined","Baselined")
which works ok stand alone, but when incorporated into a four way Switch,
also produces #ERROR.

Any suggestions?

Thanks,

Jim