use case can i replace hard coding value with search mesure or variable in complexe formula
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 :
