Is there a way to calculate rebates based on a progressive calculation. The rebate agreement is as follow.
- If a customer purchases up to 1,000 kg, they get 2% rebate.
- From 1,001 to 5,000 kg, they get 5% rebate on that portion.
- Above 5,000 kg, they get 10% rebate on the excess weight.
If a customer purchases 6,500 kg, first 1000kg will be based on 2%, second 4000 will be based on 5% and remaining 1500kg will be based on 10%.
How to setup this in IFS rebate agreement.