Tiered Commission based on sales

[kstroupe]

Hello,

I'm trying to figure out how to calculate TTL commission that is tiered based on Sales.

For example:

commission for sales 0 - 10,000 is 10%

commission for sales 10,001 - 20,000 is 12%

commission for sales 20,001 - 75,000 is 15%

commission for sales 75,001 - 100,000 is 17%

so for 50,000 in sales I would get 1000 + 1200 + 4500 = 6700 commission

Thank you.in advanced.

Kim

[sunny_talwar]

May be using IntervalMatch and doing some pre-calculation for each tier. For instance, if the sales is 50,000, we know that it will have 2200 commission from the first two tiers + 50,000 - 20,001 * 0.15. So, for each tier pre-calculate the fixed number and focus on calculating the variable portion per tier.

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

[kstroupe · Accepted solution]

Probably not the most efficient way, but the interval match wasn't working the way I really wanted.

I wrote variables and put this in the commission box.

=if($(vMax_Tax_Percentage) = .22, ($(vTier1)*.10) + ($(vTier2)*.12) +($(vBank_Amount) - $(vTier2)) *.22,
if($(vMax_Tax_Percentage) = .12, ($(vTier1) *.10) + ($(vBank_Amount) - $(vTier1)) *.12,
if($(vMax_Tax_Percentage) = .10, ($(vBank_Amount)*.10),0)))