How do I constrain output to be zero or positive numbers only?

Solved3.85K viewsFormulas and Functions
0

I want to constrain the output of a formula to be zero or positive numbers only. What do I need to add to my formula?

billy Answered question September 27, 2018
3

Wrap the formula with max(0, -your formula here- )

0

Thanks that will work.  I had not thought of that because my formula already is a min formula.  So, I actually end up with a int(max(min configuration which seems odd.

billy Answered question September 27, 2018

Latest Questions

Wrap text in scripted buttons? 1 Answer | 0 Votes
Claculate product 2 Answers | 0 Votes
Sum by group in the same matrix 4 Answers | 0 Votes
Constrain input – varchar 1 Answer | 0 Votes