Hi Expert
i have a use case in wich a need to elaborate an incentive app.
let's say i have 10 mesure. For each of those mesure i nedd to compare the result against the goal and a find the nearest step so that i can applicate a % of incentive and in final multiply this % of incentive by the final part of incentive.
See below an example with 2 mesures :
| mesures | Objectif | step | % of incentive | Part of final incentive |
| calls handled/calls received | 90% | 81% | 50% | 20% |
| calls handled/calls received | 90% | 85,5% | 70% | 20% |
| calls handled/calls received | 90% | 90% | 100% | 20% |
| réitération rate | 80% | 80% | 50% | 10% |
| réitération rate | 80% | 81% | 70% | 10% |
| réitération rate | 80% | 82% | 100% | 10% |
For example with the mesure calls handled / calls received : if the result is 84% then i need to pick % of incentive (50%) and multiply by the final part of incentive (here 20%) So i get 50% of 20% = 10 %.
so in my mesure i would like to be able to pick corresponding value ( step , % of incentive and final part ) automatically rather than write for each mesure one manually comlexe mesure :
for example :
actually :
if(
num(sum(TRAITES)/sum(PRESENTES),'00,000')>'0,90','$(=sum(1*0.2))',
if(
num(sum(TRAITES)/sum(PRESENTES),'00,000')>'0,855','$(=sum(0.7*0.2))',
if(
num(sum(TRAITES)/sum(PRESENTES),'00,000')>'0,81','$(=sum(0.5*0.2))',null())
))
Can i replace >0,90 , >0.855, >0.81 by a mesure or variable and the corresponding multiplication $(=sum(1*0.2)), $(=sum(0.7*0.2)) etc
Not sure to be clear and sorry in advance for my approximative english
Regards
