A better way to calculate completion percentage.

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 Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • Time Log Reminder

            Tracking the time spent on tasks and issues is one of the most important functions of a timesheet. However, users may forget to update the time logs because they have their own goals to achieve. But, time logs must be updated at regular intervals to keep
          • Introducing the Zoho Projects Learning Space

            Every product has its learning curve, and sometimes having a guided path makes the learning experience smoother. With that goal, we introduce a dedicated learning space for Zoho Projects, a platform where you can explore lessons, learn at your own pace,
          • Update on V2 API End-of-Life Timeline

            Dear Users, Earlier this year, we shared the launch of the V3 APIs and requested users to migrate from the older V2 APIs by December 2025. We have received valuable feedback from our users and partners regarding their migration timelines. We are happy
          • Automation Series: Auto-update Phase Status

            Hello Folks! You can auto-update your phase's status based on status of underlying tasks using custom functions. In this series, we will showcase how to create and run custom functions, using Deluge, with ease. Follow the steps below and automate your
          • Automate Timesheet Approvals with Multi-level Approval Rules

            Introducing Approval Rules for Timesheets in Zoho Projects. With this automation, teams can manage how timesheets are reviewed and approved by setting up rules with criteria and assigning approvers to handle submissions. Timesheet, when associated to

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ



                                ご検討中の方