Commission Calculations Part 3

If you’re wondering where parts 1 and 2 are, then go view the course on Formula Columns.

Let’s say that now the commissions structure is to pay differing commission rates on various tiers or buckets of sales, i.e. pay 3% on the first $50,000 in sales, 5% on the next $50k, and 7% for anything beyond that. We can do this using aggregate formulas.

Think you can figure it out another way? Go ahead, give it a try. Then, when you crash and burn, go to our next video to see how we can actually do it.

Back to Lesson