A better way to calculate completion percentage.

Currently the developed zoho project program calculates a percentage calculation on the project overview page. (See % area in picture below outlined in RED)

This percentage is currently calculated by dividing the TOTAL NUMBER OF COMPLETED TASKS by TOTAL TASKS for a project.

This is helpful but I believe another calculation would be more helpful as a substitution or in addition to the current calculation.

My suggestion would to calculate the numerator as SUM OF ALL (% COMPLETED OF TASK x TASK WORK PLANNED HOURS) and the denominator as (TOTAL TASK WORK PLANNED HOURS).

Changing this formula would give you a more accurate picture of your true completion percentage of a project.

FOR EXAMPLE:

Scenario 1: A project has two tasks. Task 1 has project completion of 100% and 25 work planned hours. Task 2 has a project completion of 0% and 75 work planned hours.

Current setup shows a completion percentage of 50%. (1 of 2 tasks are done)

My suggestion would show as [(25*1)+(75*0)]/100 or 25% (25 estimated out of 100 estimated hours are completed)

Scenario 2: A project has two tasks. Task 1 has project completion of 50% and 50 work planned hours. Task 2 has a project completion of 0% and 50 work planned hours.

Current setup shows a completion percentage of 0%. (0 of 2 tasks are done)

My suggestion would show as [(50*.5)+(50*0)]/100 or 25 percent (25 estimated out of 100 estimated hours are completed)

After using that percentage it would be nice to see a table in task overview in zoho analytics tasks dashboard that would show the following statistics:

Budgeted Hours	Actual Hours Used	% of Budgeted Hours Used	% Project Complete
124	58.1	47%	95%
281	117	42%	80%
525	48.6	9%	10%

The % project complete would be filtered by the method mentioned above.

From there you could compare the %BUDGETED HOURS USED used to % PROJECT COMPLETE to see if the project is trending ahead or behind schedule.

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Sticky Posts
Tip 37: Time Log Restriction in Zoho Projects
Timesheet in Zoho Projects helps you big time in entering log hours for the tasks and issues and approving them. Now, with the new Time Log Restriction option, you can set daily and weekly log hour limits. You can restrict users from entering extra log hours than the permissible limit. The limits are restricted to 24 hours per day and 168 hours per week by default based on business hours. To customize, navigate to Task & Timesheet settings under Portal Configuration in Zoho Projects setup and enable
Rename Task Module To Suit Your Project
Task Module in Zoho Projects gives a comprehensive view of all the action items, known as Tasks, across all projects. However, different industries may use alternative terminology for similar processes, which might not always be recognised when labelled
Project Billing with the Staff Hours Method in Zoho Projects
The Staff Hours Billing Method in Zoho Projects allows you to bill your clients based on the actual time spent by each team member on a project, at the rate set for each user. This is useful for projects where different skill sets are needed and service
Achieve Full Financial Control by Tracking Both Cost Budget and Budgeted Hours
Zoho Projects now supports tracking budget with both Cost Budget and Budgeted Hours simultaneously across all modules (Based on Project, Phase, Task, or User). Why Track Both? Tracking both cost budget and budgeted hours provides a more holistic view
🎉 Celebrate Zoho Projects’ 18th Birthday with Us! 🎉
Hello Zoho Projects Community, We’re thrilled to announce that Zoho Projects is turning 18 today! To mark this milestone, we’re hosting a special AMA (Ask Me Anything) event starting at 3 PM IST today and running until 3 PM IST tomorrow. This is your