Answered by:

Physical % Complete not rolling up for Summary Task over Milestones

Question

I'v searched and this is not something I have seen an answer for. This specifically pertains to summary task over a list of milestones.

This is MSP2007 Pro with Dec 2011 CU and SP3.

I have a summary task called Key Milestones. Under it I have several zero duration milestone tasks. The physical % complete for the milestones is 100%. However I can't get the summary line to roll up those values. The summary line is still physical % complete
equals 0%

On tasks with resources and durations, the Physical % complete rolls up fine.

Is there any way to get the roll-up to occur if the subtasks are zero duration milestones without work assigned?

MSP2007 provides me with a total physical % complete for the entire project. Is it is accurate if it ignores milestone summaries?

Answers

Thanks guys, but in MSP2007 it does. Go to Tools > Options > Calculation and click EV Method. Set that to Physical % Complete. Add EV method to a task view and change each task to Phys % Complete.

Then copy the entire column Physical % Complete and paste it back on itself. Viola.

I can guess why people miss this, but take a look in your file and you will notice that my original question holds water. Maybe it is a process issue, not sure.

I should mention, that you need to have a resource loaded schedule, the resources need a cost rate, the tasks must be baselined, and you need to have some Physical % complete values entered on the subtasks. You can't enter anything on the summary tasks manually.
But I think you guys know that.

To echo Jan�??s answer, Physical % Complete does not roll up to summary tasks for either regular tasks or milestones in any version of Microsoft Project. So I cannot imagine how you can get it to roll up on regular tasks but not on milestone tasks.
It simply DOES NOT roll up to summary tasks at all. Hope this helps.

Thanks guys, but in MSP2007 it does. Go to Tools > Options > Calculation and click EV Method. Set that to Physical % Complete. Add EV method to a task view and change each task to Phys % Complete.

Then copy the entire column Physical % Complete and paste it back on itself. Viola.

I can guess why people miss this, but take a look in your file and you will notice that my original question holds water. Maybe it is a process issue, not sure.

I should mention, that you need to have a resource loaded schedule, the resources need a cost rate, the tasks must be baselined, and you need to have some Physical % complete values entered on the subtasks. You can't enter anything on the summary tasks manually.
But I think you guys know that.

I determined that the Physical % Complete at the top schedule summary line is being calculated accurately in spite of skipping the summaries above the milestones. Still not sure why it can't roll-up physical percent complete for milestones, but I suspect
it is tied to the EV Method; you can't have EV for a task without work and cost.

As Jan and Dale has mentioned, I agree that the Physical % Complete does not roll up to summary tasks for either regular tasks or milestones in any version of Microsoft Project. Also if you copy the Physical % complete and paste on itself, it does not rollup
the values.

Haha, I am glad you chimed in because I was about to go find that post of yours and paste it here! Yes, if there is budget it will work. I calculated the % complete in Excel and it is accurate as rolled-up by the program. Thank you Andrew!

There is a way to show this. Give each of your key milestones 1d duration then go into the properties of each and on the advanced tab select 'Mark task as Milestone'. The task will now look like a milestone in the gantt chart but will now roll up in the
% complete column. If you want Work % complete to roll up just put 1% of a work type resource on each milestone. Sory doesn't seem to work on Physical % Complete no matter what I try..

I´ve got it working, pal. Maybe you need to first select all taks, open Task Information and select % physical complete. You also might need to go to Options > Advanced and select % physical complete in the EVM box.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.