Upfront!, just as a starter Not very sophisticated but find, a very simple, example as reference below and stored attached workbook version 9.3.
At least a "Classification" and "weighted" component should be included. Both component are of course "arbitrary"
if [KPI1]<=0.1 then 1
elseif [KPI1]<=0.2 then 2
elseif [KPI1]<=0.3 then 3
elseif [KPI1]<=0.4 then 4
elseif [KPI1]<=0.5 then 5
elseif [KPI1]<=0.6 then 6
elseif [KPI1]<=0.7 then 7
elseif [KPI1]<=0.8 then 8
elseif [KPI1]<=0.9 then 9
[Class KPI1]*0.2 (this component could be made "variable" based on a parameter)
Overall KPI.twbx 15.2 KB
For some odd reason, I could not open the workbook. There was an error in loading the workbook.
Suppose I have 10 different KPIs with values. Each KPI has a different criteria of what is good vs what is bad.
Also I attached sample workbook with some data. Maybe you can show me on that data
Thanks! Really appreciate it!
I provided you a workbook in version 9.3. Receiving your test2 workbook it seams you are on a "lower" version?
Which version are you on?
Cheers mate! Now I would simply need a long nested if function to sort out the data.
Thanks & appreciate the help!
Your are welcome. Thanks for the "awards":)
Quick question: I am trying to have Max & MIN colour coding for the KPIs, How would I do this?
//Also I do not want it to shade, but would like the max as a colour and Min as a colour.