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

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?

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.