use case can i replace hard coding value with search mesure or variable in complexe formula

brunobertels — Thu, 02 Sep 2021 12:04:53 GMT

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

topic use case can i replace hard coding value with search mesure or variable in complexe formula in App Development

use case can i replace hard coding value with search mesure or variable in complexe formula