ContributionsMost RecentMost LikesSolutionsRe: Setting up a sliding commission calculationTook me a little bit to wrap my head around this, but finally got it. :) At first, I was trying to make my lookup field a snapshot field. I didn't realize that a snapshot field is an additional field. Thank You! Re: Setting up a sliding commission calculationExcellent!! Will give this a try. Thanks for pointing me in the right direction.Re: Setting up a sliding commission calculationWhat 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.Setting up a sliding commission calculationI 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.....