Forum Discussion
How can I convert negative value to zero
Hi, I couldn't find a solution for this, so I really do hope that someone can support with this. I have calculation where negative values should be converted to zero. Any ideas? Thanks a lot,...
Test if the number is negative, and if so, add the abolute value of that number.
That will give you the zero.
IF( [Number] < 0, [Number] + ABS( [Number] ), [Number] )
Cheers,
--Eric.