Skip to main content

Hello Pigment Community,

This is my achievement% Metrics
 

This is my Min and Max % Metrics
 

And this is my incentive structure metrics,


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!

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 %
  )
  iREMOVE 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

 

Reply


Ask your question here!

Terms & ConditionsCookie settings