Report: % Late Tasks our of All Project Tasks

R

Ramush

Hi, how would I generate the following report:

I defined one custom field called Late Task from type Flag
IIf([Finish]<Now() And [% Complete]<100,1,0)

Now I want to define another numeric / percentage field showing what is the
percentage of tasks that are not late for the whole project? for example:

Late Task = No for 70 tasks out of 100 tasks
New Field = 70/100 showing 0.7
 
D

Dale Howard [MVP]

Ramush --

I don't believe you will be able to accomlish what you wish, which is to
calculate the percentage of late tasks. However, an alternate approach
would be this:

1. Open the Enterprise Global for editing
2. Click Tools - Customize - Enterprise Fields
3. Select a custom enterprise task Number field and rename it as Late Task
4. Use the formula: IIf([Finish]<Now() And [% Complete]<100,1,0)
5. In the Calculation for Task and Group Summary Rows, select the Rollup
option and select Sum from the pick list
6. Click OK
7. Save and close the Enterprise Global file and then exit and relaunch
Microsoft Project
8. Open a project and insert the new Late Task column
9. Press the F9 function key to recalculate the project, if necessary

In that Late Task column, your summary tasks will show you the total number
of late tasks in each phase and deliverable section of the project, and your
Project Summary Task (Row 0) will show you the total number of late tasks in
the project. Hope this helps.
 
Top