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...
Forum Discussion
Commision rate needs to be a formula - numeric field with a formula similar to the one below.
if
(
[Profit Margin]<.29,.02
,[Profit Margin]>=.29 and [Profit Margin]<31,.025
,[Profit Margin]>=.31 and [Profit Margin]<33,.035
,etc.
,etc.
,etc.
)
What if I have the commission rates set up in another table? Sometimes the commission rates change and if I change the formula, it will recalculate the old jobs with the new commission rates.
I've attached screenshot my airtable Commission rate table to help clarify what I'm asking.
Thank you for your help.
I've attached screenshot my airtable Commission rate table to help clarify what I'm asking.
Thank you for your help.