Why is the overall % percent project complete showing 99%?
Help please. I am testing the plan rollup template. My question is why is the overall % percent project complete showing 99%?
Initiate = 100
Planning & Discovery = 1
Build & Implement = 0.99
Closing = 0
Answers
-
It bases the percentage on the children. Since you have raw numbers in 3 of the children, it sees them as percentages. In this case, 1 = 100% and 0.99 = 99%. So it is understandable that it is seeing 99% for the total.
It is weighted based on the number of tasks for each section. So if you have 100 tasks for Initiate and 10 tasks for Planning & Discovery, it is going to be more heavily weighted to the Initiate complete percentage.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
Help Article Resources
Categories
Check out the Formula Handbook template!