How to create a formula at project level code that ref task lev

[Wendy]

I am trying to create three custom fields to show the rollup of durations per
phase on a project level. The issue I am encountering is created a project
level code that captures the task level custom codes for specific phases.
I can't get a handle on a specific task level fields created as the project
level.

Here are my formulas:

1) Phase 4 Task Level Custom Start Date [Enterprise Date1] with Rollup Minimum
IIf([Name]="PHASE 4-SITE SEARCH PROCESS",[Start],999999)

2) Phase 4 Task Level Custom Finish Date [Enterprise Date2] with Rollup
Maximum
IIf([Name]="PHASE 4-SITE SEARCH PROCESS",[Finish],0)

3) Phase 4 Project Level Custom Duration for Phase Does not work-
Calculation to Task Summary Rolls set to Use Formula

ProjDateDiff([Enterprise Date1],[Enterprise Date2])

It seems like my project level does not have reference to the specific Phase
4 test. This field returns a #error at the project level and an incorrect
duration of 0 days for the Phase 4 task.

Any help would be appreciated.

Thanks
Wendy

 

[Reid McTaggart]

Sorry, Wendy. I gave you a bum steer earlier. Change your formulas as
follows.

Replace both the 0 and the 999999 with ProjDateValue("NA")

I've tested this and it works.

 

[Wendy]

Hi Reid,

The task level fields now work. I did however have to change the rollups on
the task field to be use formula as they weren't working the other way
because the phases are summary tasks.

I still get a #error in the project level code.

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

Task Level formulas for start and finish with calucation 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"))

Any help would be greatly appreciated.
Thanks
Wendy

Sorry, Wendy. I gave you a bum steer earlier. Change your formulas as
follows.

Replace both the 0 and the 999999 with ProjDateValue("NA")

I've tested this and it works.
--
Reid McTaggart
EPM Architect
Microsoft

I am trying to create three custom fields to show the rollup of durations per
phase on a project level. The issue I am encountering is created a project
level code that captures the task level custom codes for specific phases.
I can't get a handle on a specific task level fields created as the project
level.

Here are my formulas:

1) Phase 4 Task Level Custom Start Date [Enterprise Date1] with Rollup Minimum
IIf([Name]="PHASE 4-SITE SEARCH PROCESS",[Start],999999)

2) Phase 4 Task Level Custom Finish Date [Enterprise Date2] with Rollup
Maximum
IIf([Name]="PHASE 4-SITE SEARCH PROCESS",[Finish],0)

3) Phase 4 Project Level Custom Duration for Phase Does not work-
Calculation to Task Summary Rolls set to Use Formula

ProjDateDiff([Enterprise Date1],[Enterprise Date2])

It seems like my project level does not have reference to the specific Phase
4 test. This field returns a #error at the project level and an incorrect
duration of 0 days for the Phase 4 task.

Any help would be appreciated.

Thanks
Wendy