Here's how to create a formula that calculates different commission rates
This formula will sum all the commissions, but once added to a table widget on a dashboard, it will show the individual commission rates of each employee.
If the won amount is between 1000 and 1999, give 1%
If the won amount is between 2000 and 2999, give 5%
If the won amount is higher than 3000, give 10%
( (Sum(Closed deal,Amount>=1000&Amount<2000,Amount)*0.01) + (Sum(Closed deal,Amount>=2000&Amount<3000,Amount)*0.05) + (Sum(Closed deal,Amount>=3000,Amount)*0.1) ) |