% 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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
@Genevieve P Thanks so much the dependencies make sense.
-
No problem! 🙂
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!