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% |