Formula Issues for Project Level Custom Duration FIeld

W

Wendy

I am trying to create a project level custom duration field to show the
rollup of durations per phase (specific summary tasks) on a project level.
The issue I am encountering a #Error on the project level code that captures
the task level custom codes for specific phases.

Here are the task level field which work:
Task Level Enterprise Date1 and Enterprise Date2 formulas for start and
finish with calculation for rollup both use formula:
IIf([Name]="PHASE 4-SITE SEARCH PROCESS",[Start],ProjDateValue("NA"))
IIf([Name]="PHASE 4-SITE SEARCH PROCESS",[Finish],ProjDateValue("NA"))

Here is the project level custom duration formula with calculation for
rollup use formula
ProjDateDiff([Enterprise Date1],[Enterprise Date2])

Any help would be greatly appreciated.
Thanks,
Wendy
 

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

How to create a formula at project level code that ref task lev 2
Weighted % Complete calculation 1
Project Level Duration Formula reference two custom task date form 1
Formula with Date custom field 8
PWA Rollup of Duration for Different Phases at Project Center 3
The custom field could not be saved due to the following reason(s):This formula contains errors. Cor 1
Proposal 3
how to stop displaying field in project professional 2007 save dia 4

Top