Forum Discussion

AnthonyWong1's avatar
AnthonyWong1
Qrew Member
2 years ago

Capped Commission Calculation

Hello!


I have a commissions calculation where I'm paying 20% of commissions owed for their first payment at a MAXIMUM of $1,000

I placed this formula in a formula - numeric field and it isn't keeping the maximum number capped at $1,000. 

Max(1000, [Actual Commissions]*0.2)

I tried switching the the items between the comma and it still didn't work. Can someone please help?

Thank You



------------------------------
Anthony Wong
------------------------------

2 Replies

  • :)

    Min(1000, [Actual Commissions]*0.2)

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AnthonyWong1's avatar
      AnthonyWong1
      Qrew Member
      .... I can't believe it

      Thank you Mark for your help

      ------------------------------
      Anthony Wong
      ------------------------------