Prev: create a new project in a trial version of MS Project
Next: Does anyone know how to add background shading to a gantt bar?
From: Mike A Mike on 24 Mar 2010 17:12
Hello All,

Was wondering if I could get some help, we are running project server 2007
latest edition with all patches. And are running a custom formula.
"IIf([Milestone]=Yes,"Milestone",IIf([PPC_Result]>=1,"100.00%",IIf([Baseline
Start]=ProjDateValue("NA") Or [Baseline Finish]=ProjDateValue("NA") Or
[Baseline Duration]=ProjDateValue("NA"),"No Baseline",IIf([Baseline
Start]>Now(),"Baseline start in future",Format(([PPC_NUM]/[Baseline
Duration]),"percent")))))"

The formula runs off a few other custom formulas.

They all work great! no problem when in project pro 2007. The only problem
comes into play when a Project Manager or owner uses the "Edit Project
Properties" button and changes a lookup table custom field and re-publishes
the data from inside PWA. The above code supplied in the column on project
center returns an "NA". Now if we open the project in PROFESSIONAL and simply
do a re-publish the formula displays correctly again.

Is this just a bug that we have to deal with or is there a way around it
when doing a simple change to a custom field via Edit Enterprise Properties
and publishing from inside PWA?
 | 
Pages: 1
Prev: create a new project in a trial version of MS Project
Next: Does anyone know how to add background shading to a gantt bar?