I am not a programmer and am trying to build a dashboard, but I need to figure out how to do a an AVG calculation.
Can someone help me with the formula?
I need to calculate the Average % Complete grouped by primary Assignment.
=AVG(% Complete) where Primary Assignment = "Business"
=AVG(% Complete) Where Primary Assignment - "Technology"
Any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!