% Complete of Summary bar

U
Uri Shachar 👤 Member for 23 years 1 month
Microsoft Project
P
Paul Harris 👤 Member for 25 years 2 months
· Permalink

The summary bar roll up value of a numeric field is determined by the “Calculation for task and group summary rows” in the Tools, Customize fields form. I would suggest you should use the “Average” option in your case.



I do not think a standard bar may be created to represent this value.



You should be able to create a new bar, say using Start1 and Finish1 fields to represent the % Complete calculated in the new Numeric field by creating a formulae to make Start1 = Start and Finish1 = Duration x the new %Complete, then create a new bar to overlay the summary bar.



Give me a call to discuss if you wish, 04 1118 7701.



Paul E Harris

Eastwood Harris Pty Ltd, Melbourne, Australia

Planning and Scheduling Book Publishers, Training & Consulting

www.eh.com.au

U
Uri Shachar 👤 Member for 23 years 1 month
· Permalink

Paul,

Thanks for your answer. Will such revised % complete for the summary bar be reflected in the progress Line?

P
Paul Harris 👤 Member for 25 years 2 months
· Permalink

Uri Shachar



I think you could do something with a Number Field and using the formula function in the Tools, Customize, Fields form.



Probably set the value of the Number Field to equal the Percent Complete and then make the summary equal to the average of the percent complete. It is a bit of messing around but if you keep trying there is a good chance you will get there.



Paul E Harris

Eastwood Harris Pty Ltd, Melbourne, Australia

Planning and Scheduling Book Publishers, Training & Consulting

www.eh.com.au

Forum Sponsor

Top Posters

Erkan Polater
9 posts
Soheil Barekat
4 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts