Getting Started

 View Only
Expand all | Collapse all

How to keep a formula from going below 0 (Keep it as 0 or higher)

  • 1.  How to keep a formula from going below 0 (Keep it as 0 or higher)

    Posted 01-04-2022 19:35
    Hello,

    I have a currency formula field that is subtracting a number of costs from a commission owed to a sales rep. The number tends to come up negative from time to time.

    I would like 1 of 2 options to support our math:

    1) Set up the currency formula field so it cannot be a number below 0.

    2) Create an additional field that will reflect the number shown in the currency formula field if it's above 0, and if it's less than 0 or a negative number, it will keep itself at 0

    In regards to option 2, I've attempted to use rules for that to occur but once the 'Project Cost' is created with the related information from another table, it will not 'fire a change' if it changes after it's been created.

    Thank You so much for your support.

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


  • 2.  RE: How to keep a formula from going below 0 (Keep it as 0 or higher)

    Posted 01-04-2022 19:39
    max(0, [my other field or formula])

    This will give the higher of zero or the other number.  So it can't be less than zero.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------