Why are my percentages not calculating correctly when this is set at the project level?
My parent/child percentages are not calculating correctly. Why is NP showing more complete than the other two departments when they are clearly behind?
Answers
-
HI @Deanna C,
This will be most likely to do with the number of days assigned to tasks. The days a task takes is weighted and without seeing the tasks within each of the phases of each section it is hard to determine the exact cause.
Are you able to expand the phases? and screenshot it to help determine exactly what the cause may be or does this answer the question?
John
-
Hi @Deanna C,
Also just a note, do you realise that the start and end dates seem to be set the wrong way round in the Project Settings?
John
-
@John_Foster - Please see expanded below. I'll post again and show you what happens to the project finish % if I change it to start date to end date. Also, all the start & end dates for each department are the same.
-
Above is with the Start/end date changed
Below is the current settings with End/Start:
-
Hi @Deanna C,
As expected the number of days within each phase is the cause for it.
In Phase 3 the tasks total 98 days as shown below and based on the % completion 66 days have been completed or 67%.
In Phase 4 the tasks total 83 days as shown below and based on the % completion 55 days have been completed or 66%.
I hope this helps make sense of this for you.
John
-
How do I correct this? Because they all have the same start/finish dates. and I'm REALLY sorry, but i'm not understanding what you are saying.
-
Hi @Deanna C,
There is nothing to correct the calculations are correct based on their weighting. The only way to amend this to show the way that you want is for the dates on the items within each phase to make sure that the total number of days of all the lowest level indented rows match for each section.
Looking at the post on 18th March, while Phase 3 spans 11 days there are 19 days of work within that phase, whereas Phase 4 has 25 days of work. This will most likely be the same across the different department levels as well.
The rolled-up % completion is based on the number of days within the whole indented section that is considered complete, the comparison you are making is not a like-for-like comparison.
John
-
@John_Foster Thank you SO much!
-
Hello, @John_Foster or anyone else - do you know if there is a way to remove that calculation from factoring in the duration? I would really like for the % complete to simply be an average of that column without weighing in the days as that is really throwing off my overall percentage. TIA!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!