Sliding Scale Commission

Hi lexiswill

I see where you are coming from. My solution was to work out the total commission for the period and you want the individual parts of the total. If you need this, then you will have to have a system where you calculate the unused balance of each commission band. With the two bands in the example this is pretty easy - it gets a bit more complicated once you have lots of bands and even more complicated when you add lots of payments.

Regards
Alastair