The meaning of the Percent of Goal is comparing the actual performance to a stated goal, the math involved in this calculation is very simple:
Divide the goal by the actual, you will get a percentage value that represents how much of the goal has been achieved.
For instance, if your goal is to sell 1000 widgets, and you sell 800, the percent of goal is 80 percent.
There isn’t much to this formula, but there is also a scenario that you need to compare actuals to a common goal, you can set up a model like this:
Please note the cell reference here to common goal is an absolute reference (toggle the absolute reference by pressing F4 key).
