Have a simple formula in a virtual column:
[col1]-[col2]+[col3]
How can I modify this result to change any negative number to 0?
max((0, [col1]-[col2]+[col3]))
Nevermind figured it out myself
FYI, there is also an ABS() function that gets the absolute value of a number. Not what you wanted here, but FYI.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |