Have a simple formula in a virtual column: ...

(Marc Dillon) #1

Have a simple formula in a virtual column:

[col1]-[col2]+[col3]

How can I modify this result to change any negative number to 0?

(Marc Dillon) #2

max((0, [col1]-[col2]+[col3]))

Nevermind figured it out myself

:smiley:

(Praveen Seshadri (AppSheet)) #3

FYI, there is also an ABS() function that gets the absolute value of a number. Not what you wanted here, but FYI.