Great stuff.  Do you have any lessons that demonstrate capped values? Commission = 67% until a capped $ amount is reached then commission is 100%.  Resets every year

---

Reply from Richard Rost:

I haven't covered that exactly, but you can do this using two other techniques I've covered. You'd need a DSUM function to count up commissions between two dates, then an IIF function to decide which commission rate to use.