Skip to Content
0
Former Member
Sep 10, 2007 at 11:46 PM

sales commission calculations

25 Views

Hi,

Has anyone set up a volume based commission model in B1? E.g. commission rate at 2% for the first $100,000, rising to 3% for all sales over this threshold. I imagine it would be based on a UDT with the rate rules but has anyone got a query worked out to calculate this?

I'm a fairly average SQL user, so any help would be gratefully received!

TIA,

Tracey