Rules for increasing value types

This is the performance definition for sales/increasing types. For sales, a higher number is better. This is the scope for non-zero target:

  • If the actual equals the target, then the value is 100%.
  • If the actual is one full target value above target (actual = target + absolute value of target), then performance value is 200%.
  • If the actual is one full target value below target (actual = target - absolute value of target), then the performance value is 0%.

With a positive target greater than zero, you can simplify the performance value calculation to:

Performance = Actual / Target

The full calculation for non-zero target which takes into consideration both a positive and negative target is:

Performance = (Actual - Target + |Target|) / |Target|

With a target of zero, the calculation is:

Performance = 1 + Actual

For a target of zero and measure of increasing type, the scope is defined to be between 0 and -1.

Examples

If target is 50:

Actual % Performance
50 100%
100 200%
0 0%
-50 -100%

If target is -50:

Actual % Performance
-50 100%
-100 0%
-150 -100%
0 200%
50 300%

If the target is zero:

Actual % Performance
0 100%
1 200%
-1 0%
-2 -100%
2 300%