% Complete Formulas

Johnna Van

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.

Bassam Khalil

Hi @Johnna Van 

Hope you are fine, you can get the correct percentages if you apply this formula at the parent level

=AVG(CHILDREN())

Genevieve P.

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

Bassam Khalil

Hi @Johnna Van 

Hope you are fine, you can get the correct percentages if you apply this formula at the parent level

=AVG(CHILDREN())

Genevieve P.

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

Johnna Van

@Genevieve P Thanks so much the dependencies make sense.

Genevieve P.

No problem! 🙂