possible to calculate % attainment using one formula?
I need to measure one set of data over the other. For example, Set A is
forecast and Set B is actuals.
Set A 591 107 (160) (559) (159)
Set B 362 (24) 50 (121) (295)
First pair of data is simple. 362/591= 61%. This means acutals is 61% to
fcst.
Is there a formula to cater to all scenarios above?
|