Hello,

I would like to create a formula in QPR Metrics where an overall percentage performance rating does not go below 0% or beyound 100%. For example in measuring turn-around times, the target will be 5 days which will be 100% and the alarm 8 days which is 0%. If the actual is less than 5 days the percenatge rating should still be 100% and no further. If the actual is beyound 8 days, the percenatge rating should be 0% and should not be a nigative figure. How do I go about creating a formula to meet these requirements?

Sorry made some spelling mistakes above

I would like to create a formula in QPR Metrics where an overall percentage performance rating does not go below 0% or beyond 100%. For example in measuring turn-around times, the target will be 5 days which will be 100% and the alarm 8 days which is 0%. If the actual is less than 5 days the percentage rating should still be 100% and no further. If the actual is beyond 8 days, the percentage rating should be 0% and should not be a negative figure. How do I go about creating a formula to meet these requirements?

Hi Theophilus,

If I understood you correctly, you can achieve this by using IF formulas to limit the calculation. The real deal with performance rating / actualization percentage is how to calculate it correctly when it'a minimise measure. You can "wrap" your calculation between IF clauses, which directly give the result when limits are reached, for instance IIF(ACT()>=ALA(), 0,......) this will directly give 0 to the percentage serie when Actual is equal to / bigger than Alarm serie. Also another IF to cover to low end, for 100%. Then in between you can have your original formulation to calculate the percentage.

Thank you Ozan, for your answer. However I am failing to understand. Kindly give another example. You seem to be on the right track.

Hi Theophilus, this should do the job:

max(min(100,<percentage here>),0)

Thank you Antti. I'll try your formula.

Ozan, your formula seems to be doing the job.