Scaled rebate tier with exclusion on payout

[Duncan_Burns]

Hi community!

We are setting up customer rebates and have come across a scenario where we need some advice...

The agreement with the customer is that their rebate scales are based on the Total Sales: 

£0 - £1m = 0%

£1m - £2m = 1%

£2m + = 2%

However, once you determine the scale they have hit you have to exclude all of the sales for materials that are in the group 'Boilers'.

So, if the customers total sales were £1.5 million they would have hit the 1% scale. If £0.5 million of those sales were for Boilers then the rebate payout would be (£1.5m - £0.5m) = £1m x 1% = £10,000

How would we set this up in CCM?

[gvictor]

Hi @Duncan_Burns , 

I believe you will need to have your condition record at non-boilers level but the scale basis based on your total business volume. 
Then your condition should not be trigger for the material part of Boilers group and it should calculate for the rest.  

Regards, 
Gauthier