Question Building pyramid Calculation

[AVERNEKAR]

Hello,

I am trying to build a calculation that adds up the values depending on the percentage value. So if someone has 120 % attainment he gets 5250 + 1150 , if he gets 140 %, he gets pier for 100% + 120 % + 140% and so on.

Goal $115,000 Net Rev Attainment Additional Money Earned Calc Payout Per Tier Total Payout $ 115,000 100% $ 5,250 5250 $ 138,000 120% (138,000-115,000=23,000*5%) $ 1,150 6400 $ 161,000 140% (161,000-138,000=23,000*10%) $ 2,300 8700 $ 184,000 160% (184,000-161,000=23,000*15%) $ 3,450 12150 $ 189,750 165% (189,750-184,000=5,750*20%) $ 1,150 13300

 

[jmcilhinney]

Do you currently have that data stored somewhere? If so, where?