Forum Discussion
kati70
9 years agoRegular Visitor
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,...
Baskar
9 years agoResident Rockstar
Ya we can do .
If ( measure < 0 , 0 , measure )
thats it.
let me know if any further help.
Anonymous
5 years agoNot applicable
I am wondering if this is the optimal way or if using the function max( measure, 0) performs quicker.
(apologies for ressurecting an old thread!)