Project Level Duration Formula reference two custom task date form

[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.

For example here:
Project A
PHASE 4-SITE SEARCH PROCESS
Interview
Conduct Analysis
PHASE 5-HIRING
Obtain funding
Hire contractor

Basically I need a PWA Project Center view that shows the task duration
rollups for all the phases for a Project (ie Phase 4 Task Duration, Phase 5
Task Duration etc across all the projects in an enterprise). This is an easy
task at the Project Level Detail view but not as rollup of all projects in
the PWA Project Center.

In order to do this I need to create a project level fields that captures
the durations of each phase.

The issue I am encountering a #Error on the project level code that captures
the task level custom codes for specific phases.

Here is an example of two of the task level field which work:
Task Level Enterprise Date1 and Task Level 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])

This formula returns the #Error. Is there something I need to specifiy so
it only picks up the dates for the Phase 4 at the project level as well. I
have tried everything. If you could please confirm the calculation for
rollups settings are correct.

If anyone can correct this project level formula so it accurate captures the
duration for a specific phase I would greatly appreciate it.

Thanks
Wendy

 

[Dean C]

Wendy,
Taking a different approach to your problem, it sounds like you desire the
duration from the earliest start date for a phase to the latest finish date
for a phase across all projects.

Try customizing a number or text field to enter the phase number, then
grouping on phase. If you rename the field used to "Phase", and simply use
numbers, the result will be new GroupBySummary tasks named "Phase: 1", etc.
If you use a text field, populated with "4-SITE SEARCH PROCESS", the result
will be "Phase: 4-SITE SEARCH PROCESS".

If grouping doen't work for you, try trouble-shooting by establishing
non-enterprise custom start and finish fields for each phase. For example,
for the custom field "phase 4 start", enter the formula "Iif([Phase]= "Phase
4", [Start],"NA") for Summary tasks, rollup minimum. For the finish, rollup
the maximum. Copy these fields to each project. Create a consolidated project
comprising all of your projects and display the consolidated project summary
task. Use your duration formula in the consolidated file as it is. If this
works, then the problem probably lies with the lack of specifying a calendar
in the formula. A consolidated schedule will have a project calendar, I'm not
sure what happens at the enterprise level.

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.

For example here:
Project A
PHASE 4-SITE SEARCH PROCESS
Interview
Conduct Analysis
PHASE 5-HIRING
Obtain funding
Hire contractor

Basically I need a PWA Project Center view that shows the task duration
rollups for all the phases for a Project (ie Phase 4 Task Duration, Phase 5
Task Duration etc across all the projects in an enterprise). This is an easy
task at the Project Level Detail view but not as rollup of all projects in
the PWA Project Center.

In order to do this I need to create a project level fields that captures
the durations of each phase.

The issue I am encountering a #Error on the project level code that captures
the task level custom codes for specific phases.

Here is an example of two of the task level field which work:
Task Level Enterprise Date1 and Task Level 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])

This formula returns the #Error. Is there something I need to specifiy so
it only picks up the dates for the Phase 4 at the project level as well. I
have tried everything. If you could please confirm the calculation for
rollups settings are correct.

If anyone can correct this project level formula so it accurate captures the
duration for a specific phase I would greatly appreciate it.

Thanks
Wendy