muckwomper
Programmer
I’ve been trying to solve a reporting issue at the project level. The goal is to report the 'Phase' of the first task not complete within a 'Project Information' report.
We have an outline code at the task level to indicate 'Phase' of the project. What we want to report at the project level is the first task found (in row ID order) in which the '% Complete' is not 100% and display the 'Phase'. Projects may have different phases orders so implementing a solution as seen at the following link is not applicable.
I have been able to determine the row I want to report the phase of with the following formula within a Custom Enterprise Field: Task Number: [Enterprise Number 1]
IIf([% Complete]=100,99999,[ID])
This field is set to Rollup: Minimum.
From here I need to show the 'Phase' for that ID row.
Any ideas? Please help!!!
We have an outline code at the task level to indicate 'Phase' of the project. What we want to report at the project level is the first task found (in row ID order) in which the '% Complete' is not 100% and display the 'Phase'. Projects may have different phases orders so implementing a solution as seen at the following link is not applicable.
I have been able to determine the row I want to report the phase of with the following formula within a Custom Enterprise Field: Task Number: [Enterprise Number 1]
IIf([% Complete]=100,99999,[ID])
This field is set to Rollup: Minimum.
From here I need to show the 'Phase' for that ID row.
Any ideas? Please help!!!