% Complete Formulas
Hello and good day I'm getting 3 different percentages when using the following formulas:
=avg(children)): I have one main parent row with several children and getting 42%
=AVG([% Complete]2:[% Complete]195) and getting 35%
Using the project setting and enabling dependencies with % Complete column I'm getting 73%
I need to ensure that the % Complete column is 100% accurate. Please let me know.
Best Answers
-
Hi @Johnna Van
Hope you are fine, you can get the correct percentages if you apply this formula at the parent level
=AVG(CHILDREN())
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Johnna Van
Is it possible that not all rows from row 2 - 195 are set up as child rows? If some of the rows at the bottom are not indented below the parent row, they wouldn't be included in the CHILDREN function.
In regards to the % Complete within Project Settings with dependencies, this percentage calculates a weighted average, which is why you're seeing a different number. The Project % Complete takes into account the duration as well as the percentage. (See this Help Article on the Parent Rollup functionality.)
For example, this means a task which only lasts 1 day does not weigh the same as a task that lasts 10 days:
Let me know if this makes sense or if I can clarify anything further for you!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
Hi @Johnna Van
Hope you are fine, you can get the correct percentages if you apply this formula at the parent level
=AVG(CHILDREN())
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Johnna Van
Is it possible that not all rows from row 2 - 195 are set up as child rows? If some of the rows at the bottom are not indented below the parent row, they wouldn't be included in the CHILDREN function.
In regards to the % Complete within Project Settings with dependencies, this percentage calculates a weighted average, which is why you're seeing a different number. The Project % Complete takes into account the duration as well as the percentage. (See this Help Article on the Parent Rollup functionality.)
For example, this means a task which only lasts 1 day does not weigh the same as a task that lasts 10 days:
Let me know if this makes sense or if I can clarify anything further for you!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
@Genevieve P Thanks so much the dependencies make sense.
-
No problem! 🙂
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!