% Complete of Summary bar

P
Paul Harris 👤 Member for 25 years 1 month

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

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 1 month

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

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts