Calculate a capped amount based on client. For example, if the same client has multiple deals for the year, commissions should only be paid on an annual capped amount of 250K even if the total is over 550, see example below.
Company Deals
A 100
B 200
C 150
A 200
A 250
I would like to cap Company A sales at 250. Please advise.
Much appreciated!
Bookmarks