This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

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

Posted on 11-01-2018 05:00 PM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Have a simple formula in a virtual column:

[col1]-[col2]+[col3]

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

0 2 336
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

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

Nevermind figured it out myself

0 Likes

Posted on --/--/---- --:-- AM
pravse
Staff
Reply posted on --/--/---- --:-- AM

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

0 Likes
Top Labels in this Space