![](https://media.stonly.com/media/images/c8ac7808-0297-4e88-bc18-b12ee7ffb82f.png?s=05646d58173ee9348fffe923073428477825562754e3e855665128e695d7a0054933ef251b4b7f769e8efae8b5cdc2282c3e109d3e970804095f2aa3ae7b4cd87b4b4c84044e7bd552bdeaaa1a12f9605e5301b53c5b69d6c8966f5e40befe65d1b903ab3eb52aa89b664c64401a186b&w=1280&h=1440&auto=format)
![](https://media.stonly.com/media/images/c8ac7808-0297-4e88-bc18-b12ee7ffb82f.png?s=05646d58173ee9348fffe923073428477825562754e3e855665128e695d7a0054933ef251b4b7f769e8efae8b5cdc2282c3e109d3e970804095f2aa3ae7b4cd87b4b4c84044e7bd552bdeaaa1a12f9605e5301b53c5b69d6c8966f5e40befe65d1b903ab3eb52aa89b664c64401a186b&w=1280&h=1440&auto=format)
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) ) |