KPI Calculation and using Exception

[Former Member]

Hi all,

In my current project we have to calculate certain KPIs of my company and have to compare them with target value and put the result in Green or yellow or red zone using exception.

EX:- KPI 1 = (# of associates having completed training)/(Total # of planned associates to attend training)×100

So here first I have to calculate KPI 1 and put the result % in KPI and then if you see below table as next step

       Target Value KPI Color zone

Pharma 10% 20% Green

  America 20% 30% Green

    US     50% 40% Yellow

  Europe  30% 15% Red

CH 40% 20% RED

DE 50% 10% RED

In above table we need to check the KPIs

Green if KPI>Target value

Yellow if KPI is + or - 10% of target value

Red if KPI is < 10% of Target value

Now my question is how to calculate the KPI and target value difference, how to put them in Exception to get color zones display in report using above 3 conditions?

Please suggest...

Thanks,

Preethi

[Former Member]

Hi Preethi,

Just create one more KF which will calculate teh difference between KPI and Target value. Make it invisible in the report. And based on the values got for that KF you can decide on the colour .

If New KF = 0 Green

If New KF lies betwee +10 to -10 Yellow

Else Red

Navesh

[Former Member]

can you please elaborate your solution?

to be more specific my requirement is as below.

Please treat each as a column in bellow with respective values.

Associates completed training, Total no. of associates planned to take training, Ratio/KPI, Target value , difference

20 , 30, 67% ( 20/30*100) , 80%, 13% (difference of Target value value and KPI/Ratio)

we have to check below conditions and give coloring to KF ratio/KPI

If ratio/kpi > target value

ratio/KPI= Green

elseif

Target value - ratio/kpi <10%

ratio/KPI = Yellow

else

ratio/KPI = RED (i.e, target value - ratio >10%)

Now can you help me....

Thanks,

preethi