G
Gene
I think I posted this to the wrong group earlier. I should have posted
it here for Project Developers.
We are using Project Server 2003 and have a number of Enterprise Task
Text fields that display some indicator to show if the task is on-time,
etc. The problem is when using Project Pro 2003 we have not found a
calculation that recognizes if a task has been baselined. The
Enterprise Task Text filed displays #ERROR if the calculated field
tries to use a non-baselined field in a calculation. Can someone give
me a formula to identified that a baseline field has not been populated
(i.e. Baseline Start has not been populated)?
Here is a formula we tried, but the Len(CStr([Baseline Finish]))<3,"No
baseline" doesn't work.
Switch([Status]=0,"Completed",[Status]=3,"Future",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 here for Project Developers.
We are using Project Server 2003 and have a number of Enterprise Task
Text fields that display some indicator to show if the task is on-time,
etc. The problem is when using Project Pro 2003 we have not found a
calculation that recognizes if a task has been baselined. The
Enterprise Task Text filed displays #ERROR if the calculated field
tries to use a non-baselined field in a calculation. Can someone give
me a formula to identified that a baseline field has not been populated
(i.e. Baseline Start has not been populated)?
Here is a formula we tried, but the Len(CStr([Baseline Finish]))<3,"No
baseline" doesn't work.
Switch([Status]=0,"Completed",[Status]=3,"Future",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")