Task Management Software for Team Collaboration
 
HomeDownloadSupportPurchase
 
SupportFAQForumHelpdeskCompanyContact Us

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?

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?
   
Home  » Support  » Frequently Asked Questions (FAQ)  » 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
  7. ToFloat(ToString($estimated_time)) * $complete/100

  8. Click on 'New' button in 'Edit custom fields' window
  9. Enter 'Total % Complete' into Title field in 'Edit Custom Field' window
  10. Select 'Float' in Type Field in 'Edit Custom Field' window
  11. Uncheck 'Required' option in 'Edit Custom Field' window
  12. Enter the below formula into 'Formula:' filed in 'Edit Custom Field' window
  13. $cf_earned_hours/ToFloat(ToString($estimated_time))*100

  14. Enter '#0.00 %' into 'Display Format:' field in 'Edit Custom Field' window and click 'OK' button
  15. Click 'OK' button in 'Edit custom fields' window
  16. Go to View menu, select option Columns, select option Task Tree Columns and activate option 'Earned Hours'
  17. Go to View menu, select option Columns, select option Task Tree Columns and activate option 'Total % Complete'
  18. Go to Task Tree tab
  19. Right click on a task group (ex.: 'Projects') and select option 'Custom fields options'
  20. Select 'Earned Hours' field in 'Edit custom field options for 'Projects' window
  21. Select 'Subgroups&Tasks' option in 'Settings For:' field in 'Edit custom filed options for 'Projects' window
  22. Select 'Enable' option in 'Field: Earned Hours' in 'Edit custom field options for 'Projects' window
  23. Select 'Sum' and 'Earned Hours' in drop down lists in option 'Aggregated (for taskgroup)'
  24. Select 'This task group' option in 'Settings For:' field in 'Edit custom field options for 'Projects' window
  25. Select 'Enable' option in 'Field: Earned Hours' in 'Edit custom field options for 'Projects' window
  26. Select 'Sum' and 'Earned Hours' in drop down lists in option 'Aggregated (for taskgroup)'
  27. Select 'Total % Complete' option in 'Edit custom field options for 'Projects' window
  28. Select 'Subgroups&Tasks' option in 'Settings For:' field in 'Edit custom field options for 'Projects' window
  29. Select 'Enable' option in 'Field: Total % Complete' in 'Edit custom field options for 'Projects' window
  30. Select 'Calculated by custom field formula (for taskgroup)' in 'Edit custom field options for 'Projects' window
  31. Select 'This task group' option in 'Settings For:' field in 'Edit custom field options for 'Projects' window
  32. Select 'Enable' option in 'Field: Total % Complete' in 'Edit custom field options for 'Projects' window
  33. Select 'Sum' and 'Total % Complete' in drop down lists in option 'Aggregated (for taskgroup)'
  34. Click 'OK' button in 'Edit custom field options for 'Projects' window



Available: Workdays, Monday - Friday
8 am - 8 pm GMT for Europe/Asia
1 am - 1 pm PST for America


Skype

My status

Available: Workdays, Monday - Friday
8 am - 8 pm GMT for Europe/Asia
1 am - 1 pm PST for America




Feb 1, 2016 TopTenReview: VIP Organizer is one of the best organizer software
TopTenReview has published Organizer Software Review 2016 and our product has been included to the list of the best software programs for personal information management. The author considers VIP Organizer to be a good choice if you are looking for something simple to help you organize your days.

More News


Login:
Password:
Register
Forgot your password?
Login As:
Login As
You can log in if you are registered at one of these services:

ProductsSolutionsDownloadSupportPurchaseContactsForumVideoMy Account
Copyright © 2004 - 2017 Task Management Software
 
          
 
Site Map