WilliamBedingfi
7 years agoQrew Trainee
Setting up a sliding commission calculation
I would like to automatically populate the commission rate based on the profit margin. I have set this up in MS Excel and also Airtable.com, but not sure how to go about this with quickbase .
For example(see screenshot): In the attached example has a 20.46% profit margin and would pay a 2% commission.
Here is the commission scale:
Profit Margin 00.00% to 28.99% profit margin pays 2% commission rate
Profit Margin 29.00%-30.99 pays a 2.5% commission rate
Profit Margin 31.00-32.99% pays a 3.5% commission rate
Etc, etc.....
For example(see screenshot): In the attached example has a 20.46% profit margin and would pay a 2% commission.
Here is the commission scale:
Profit Margin 00.00% to 28.99% profit margin pays 2% commission rate
Profit Margin 29.00%-30.99 pays a 2.5% commission rate
Profit Margin 31.00-32.99% pays a 3.5% commission rate
Etc, etc.....