# I'm trying to make a tier commission table but unsure of a formula.

• 0
• Question
• Updated 3 years ago
I'm trying to make a tier commission table but unsure of a formula. Commission is calculated on total sales e.g <\$950, 20% commission >\$950, 25% Commission I need to show the Total Sales amount in a Currency, the Commission % and also the total Commission being paid in a Currency. help!
• 0 Points

Posted 3 years ago

• 0
• 70 Points
Hi Amy,

Screenshot Prototype is attached.

Xavier Fan has explained to write formula in the following article.

https://quickbase-community.intuit.com/questions/1170579-need-help-with-sales-commission-formula

Use the above article to write your formula to get numeric-Commission.

Basically it will be Commission =  (Sales * Percentage) / 100

Thanks,

Neal

NealPatil @ gmx.com

QuickBaseCoach App Dev./Training, Champion

• 65,280 Points
Amy,

The formula for the Commission % would be a formula numeric field set to display in Percentage called [Commission %]

IF([Total Sales] < 950, 0.2, 0.25)

The formula for the [Commission \$] would be

Round([Total Sales] * [Commission %],0.01)

The round function will round to the nearest cent.