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.

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

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

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
Auto-update the Successor Task Status.
Hello folks! We have come up with a new use case for custom function to help you automate the workflow of your tasks. Users can write their own Custom Functions using deluge and call them from a workflow. Consider a scenario where the status of the successor
Collaborate Visually with Whiteboard in Zoho Projects
Whiteboard in Zoho Projects allows you to collaborate visually by creating diagrams, annotating designs, and sketching project workflows using shapes, text, and images within project modules. Team members can work simultaneously, improving productivity
Introducing Projects 8.0 - Focusing on Ease-of-Use and New Features
Hello everyone! It's time for the reveal of the 8th version of Zoho Projects! This year our focus has been on minimizing the learning curve and improving the ease-of-use of the tool, so anyone new to Projects can hit the ground running and existing users
Manage Documents with SharePoint Extension in Zoho Projects
SharePoint is a digital platform to store and manage your documents. Multiple users can work on the same document simultaneously, which enhances your team's productivity. By installing the extension in Zoho Projects, users can access the documents seamlessly
Work agile in Zoho Projects! The much-awaited Zoho Sprints integration is in the making.
Let your teams work in both classic and agile methodology using our integration with Zoho Sprints. We made sure you get the best of both worlds with this integration. You can scale through teams irrespective of what methodology they use and make sure they work with speed and flexibility. And, you can do it all from one place- Zoho Projects. Why this integration is a benefit? This integration mostly helps in managing classic and agile practices together. Most organizations use a mix of both classic