Calculated parent % complete issue

JAM_BFT · 04/20/22

Hello -

We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples that show the problem. You can see that the cost rolling up is not the same as the % complete of the total.

We have shown that the issue is with how the % complete of the parent tasks is being calculated. Any thoughts on what may be going on?

JAM_BFT · 04/25/22

I went through and reconstructed the calculations in Excel. The issue is (as I am using it) that "% Complete" is simply a weighted average of the total days in the children. The fact that separate tasks have different monetary values over different durations renders the assumption incorrect. I am going to have to adjust all of the "BCWP [$]" to be "=sum(children())" because each task has a very different $/work day.

Thanks for the help.

I like the concept of using a column function but is there any way to make the function use "=sum(children())" where the children are 0?

James Keuning · 04/21/22

what's the formula?

JAM_BFT · 04/22/22

The formula is:

BCWP = BCWS * % complete at the child level

At the parent level it is the same formula but it uses the Smartsheet calculated rolled up % complete. The issue seems to be related to how % complete at the parent levels is calculated. I have manually check the % complete and can reproduce at a lower level but not at the parent level.

James Keuning · 04/23/22

What numbers are you expecting to see, and where?

JAM_BFT · 04/25/22

I went through and reconstructed the calculations in Excel. The issue is (as I am using it) that "% Complete" is simply a weighted average of the total days in the children. The fact that separate tasks have different monetary values over different durations renders the assumption incorrect. I am going to have to adjust all of the "BCWP [$]" to be "=sum(children())" because each task has a very different $/work day.

Thanks for the help.

I like the concept of using a column function but is there any way to make the function use "=sum(children())" where the children are 0?

Calculated parent % complete issue

Best Answer

Answers

Help Article Resources

Categories