Overall Status with Weighted Average
I have a project split by 8 different milestones, is there a way to add a weighted average of completion? For example Milestone A and all of the tasks under it should account for 5% of the project completion, Milestone B and all of it's tasks should account for 15%.
Answers

Hi @Kristin Fortner, you can create a formula that will weight the completion average. Assume you have three projects with the below details. I'll use CompleteA, CompleteB, and CompleteC as a stand in for any calculation or reference you use to generate the percent complete for each of the subprojects. Weight, below, is in reference to the weighted percentage of each individual subproject.
Project A, Weight: 20%
Project B, Weight: 40%
Project C, Weight: 60%
The total calculated completion would then be a formula like this:
=0.2*CompleteA + 0.4*CompleteB + 0.6*CompleteC
For instance, if Projects A, B, and C were 55%, 35%, and 87% complete, respectively, the formula would resolve to:
02*0.55 + 0.4*0.35 + 0.6*0.87 = 0.772
So the overall project in this case would be 77.2% complete.
Let me know if that makes sense!
Help Article Resources
Categories
Check out the Formula Handbook template!