Show summery complete to each milestone

Kimosabi · Feb 3, 2006

I've heard this is not possible in Microsoft Project. I would like the progress bar that is within my summery bar to stop at the last complete milestone (which has been rolled up to the summery bar). As it stands, Project will only add up the percentages complete and apply an overall average completion to the summery bar. I have the milestones showing complete when they are designated as 100 percent, but I would like the progress bar within the summery bar to be based on those completions. Any way possible?

Kimosabi · Feb 17, 2006

I'm answering my own question on this one. Finally figured it out. You create a "Finish 1" column and name it something like "Complete To" for your own convienience. Once its created you go into the "Customize Fields" setup- (a right-click will get you there). In the Customize Fields setup, you set Finish 1 to "rollup maximum" using the buttons at the bottom of the window, and a pull down menu there. You also set an "If" formula for the Finish 1 fields so that they reflect the regular Finish date, if the milestone is 100% complete. You then set your "Bar Styles" under the Format menu, so that rolled up progress begins at the start date, and ends at the Finish 1 column date.

It works well. I know a lot of folks would like to know this one.

BHBPCP · Apr 27, 2006

Hi,

I have tried to recreate this but have had no joy. Could you copy a couple of phases into a balck project so I can see how you did it. I'm at trevorroberts@hsbc.com. Obviously, kill off any sensitive stuff but I think what you have described is what I am tryign to do.

Regards,

Trevor

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Show summery complete to each milestone

Kimosabi

Aerospace

Recommended for you

Kimosabi

Aerospace

BHBPCP

Computer

Similar threads

Part and Inventory Search

Sponsor