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