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

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
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!
Photo of Amy

Amy

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Neal

Neal

  • 70 Points
Hi Amy,

Screenshot Prototype is attached.

Please provide feedback.

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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,268 Points 50k badge 2x thumb
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.