The cumulative completion percent is based on the average of all tasks percent complete under that branch and not the weighted total percent. How to make the total percentage more accurate?

To calculate weighted total completion percent as it’s shown at the second screenshot above, please, do the following steps:

1. Go to menu Tools and select option Custom Fields



2. Click on 'New' button in 'Edit custom fields' window



3. Enter 'Earned Hours' into Title field in 'Edit Custom Field' window



4. Select 'Duration' in Type Field in 'Edit Custom Field' window



5. Uncheck 'Required' option in 'Edit Custom Field' window



6. Enter the below formula into 'Formula:' filed in 'Edit Custom Field' window and click 'OK' button

ToFloat(ToString($estimated_time)) * $complete/100



7. Click on 'New' button in 'Edit custom fields' window



8. Enter 'Total % Complete' into Title field in 'Edit Custom Field' window



9. Select 'Float' in Type Field in 'Edit Custom Field' window



10. Uncheck 'Required' option in 'Edit Custom Field' window



11. Enter the below formula into 'Formula:' filed in 'Edit Custom Field' window

$cf_earned_hours/ToFloat(ToString($estimated_time))*100



12. Enter '#0.00 %' into 'Display Format:' field in 'Edit Custom Field' window and click 'OK' button



13. Click 'OK' button in 'Edit custom fields' window



14. Go to View menu, select option Columns, select option Task Tree Columns and activate option 'Earned Hours'



15. Go to View menu, select option Columns, select option Task Tree Columns and activate option 'Total % Complete'



16. Go to Task Tree tab



17. Right click on a task group (ex.: 'Projects') and select option 'Custom fields options'



18. Select 'Earned Hours' field in 'Edit custom field options for 'Projects' window



19. Select 'Subgroups&Tasks' option in 'Settings For:' field in 'Edit custom filed options for 'Projects' window



20. Select 'Enable' option in 'Field: Earned Hours' in 'Edit custom field options for 'Projects' window



21. Select 'Sum' and 'Earned Hours' in drop down lists in option 'Aggregated (for taskgroup)'



22. Select 'This task group' option in 'Settings For:' field in 'Edit custom field options for 'Projects' window



23. Select 'Enable' option in 'Field: Earned Hours' in 'Edit custom field options for 'Projects' window



24. Select 'Sum' and 'Earned Hours' in drop down lists in option 'Aggregated (for taskgroup)'



25. Select 'Total % Complete' option in 'Edit custom field options for 'Projects' window



26. Select 'Subgroups&Tasks' option in 'Settings For:' field in 'Edit custom field options for 'Projects' window



27. Select 'Enable' option in 'Field: Total % Complete' in 'Edit custom field options for 'Projects' window



28. Select 'Calculated by custom field formula (for taskgroup)' in 'Edit custom field options for 'Projects' window



29. Select 'This task group' option in 'Settings For:' field in 'Edit custom field options for 'Projects' window



30. Select 'Enable' option in 'Field: Total % Complete' in 'Edit custom field options for 'Projects' window



31. Select 'Sum' and 'Total % Complete' in drop down lists in option 'Aggregated (for taskgroup)'



32. Click 'OK' button in 'Edit custom field options for 'Projects' window