Can I make a calculated field have a minumum of 0?

  • Profile Image
    bkclouse
    Asked on November 23, 2021 at 04:34 PM

    We have a few calculated fields and sometimes the result comes back as a negative number, which is technically the correct number.

    However, we are calculating physical objects, so if they've used all their objects, then the number should display as 0 instead of a negative number. I've tried using conditions for calculated fields, but it's causing issues. Is there a different way to approach this?

  • Profile Image
    Yau
    Answered on November 23, 2021 at 09:40 PM

    Hi,

    You can assign the value of calculation field to another shorttext field (or a number field) by using conditional logic and keep the calculation field to hidden.

    Your conditional logic should be similar to:


    If 'calculation field' is greater then zero

    then assign 'calculation field' to shorttext field.


    If 'calculation field' is less then zero

    then assign 0 to shorttext field.


    Then show this shorttext field as the final result to your user.