Enterprise Custom Fields

[julie]

I'm currently using Project 2003 and Project Server 2003.

Why is it that when I enter the following formula in a custom text field,
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")

 

[Chris Marriott]

Julie

As an alternative to this try

iif(isnumeric([baseline start]+1)=-1,"no baseline",- rest of your formula

This will most certainly produce the desired result.

--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer

 

[julie]

Even with this statement along I get #ERROR when I look at the Project
Information Section. I tried changing something within the schedule and
republishing. Same thing.

Here is the exact statement: IIf(isnumeric([Baseline Start]+1)=-1,"no
baseline","baseline")

Julie

As an alternative to this try

iif(isnumeric([baseline start]+1)=-1,"no baseline",- rest of your formula

This will most certainly produce the desired result.

--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer

I'm currently using Project 2003 and Project Server 2003.

Why is it that when I enter the following formula in a custom text field,
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")

 

[Gary L. Chefetz [MVP]]

Julie:

Try using

projdatevalue("NA")

to detect null date values in Project date fields

ie:

IIf([Baseline Finish]=projdatevalue("NA"),"I dont have a baseline",...

 

[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 works for me.

Gérard Ducouret

 

[julie]

Thanks so much, this work. I've been struggling with this for a while now.

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 works for me.

Gérard Ducouret

I'm currently using Project 2003 and Project Server 2003.

Why is it that when I enter the following formula in a custom text field,
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")