Enterprise Customer Fields

[julie]

Why is it that when I enter the following formula, found in the Server 2003
Application Configuration Guide, I get an error on any schedule that doesn't
have a baseline set. I would expect to get a "No baseline" message returned
instead I get a #Error.

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")

 

[Mike Glen]

Hi Julie,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Gérard Ducouret]

Hello Julie,
Try this one :
IIf([Baseline Finish]=ProjDateValue('NA');"No
Baseline";IIf(ProjDateDiff([Baseline Finish];[Finish])/480>=5;"Late by more
than 5 days";IIf(ProjDateDiff([Baseline Finish];[Finish])/480>0;"late";"On
schedule")))

It work for me.

Gérard Ducouret