Now here (1,2,3 and 4) signifies the slabs, that is, if the achievement% is between the min and max percentage then it will receive the incentive of the following slab, for example if a person achieved 102% and is a team member, he will receive 30% as incentive and so on.
This is my final metric:
Please kindly guide me with the formula, the formula which I entered is not showing correct results.
Thanks a lot!
Best answer by oliverlee
Hi @Spandan98,
I assume your incentive structure metric is called “Topline” as this is what’s shown on the screenshot. Further I will assume that your dimension that’s giving you the integers 1,2,3 and 4 are called “Slab”.
Please check if you get the correct result by trying this formula in the playground:
IF( ‘Achievement %’ >= ‘Min%’, // check if achievement exceeds min. % Topline // return incentive % ) [REMOVE LASTNONBLANK: Slab] // get the last slab that meets requirements, assuming that the Slabs are ordered in a way where 1 = lowest incentive and n = highest incentive
I assume your incentive structure metric is called “Topline” as this is what’s shown on the screenshot. Further I will assume that your dimension that’s giving you the integers 1,2,3 and 4 are called “Slab”.
Please check if you get the correct result by trying this formula in the playground:
IF( ‘Achievement %’ >= ‘Min%’, // check if achievement exceeds min. % Topline // return incentive % ) [REMOVE LASTNONBLANK: Slab] // get the last slab that meets requirements, assuming that the Slabs are ordered in a way where 1 = lowest incentive and n = highest incentive
