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