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