Custom Fields/Formulas Receiving an error "NA" in Project Center

M

Mike A

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Need some PWA help 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Tracking , Resource Loading & % Complete querry 0
Custom fields in Project 2007 3
Calculated Field Expected % Complete Error 6
Need help with 'Status Date' custom field 7
Tracking EV with a formula 3

Top