Parent Row Calculation

Anoop Phago

Hello.

I want to know how exactly the the Complete % of the parent row is calculated by Smartsheet.

I though it was the average of the child row but I think I am wrong.

As per the attached picture you can see the average of the Complete is % 0.24 i.e 24%

where as in the parent row its only 12%.

Please explain me how the parent row calculates the Complete %?

Bassam Khalil

Hi @Anoop Phago

Hope you are fine, it's not the average it's weighted average using AVGW function and it use the duration as a weight.