Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! What formula can I write to turn a negative number into a "0" and show positive numbers normally?
I need to have the value "0" when negative numbers appear
Try this
If([Your Expression]<=0,0,[Your Expression])
I would define in script
load *,
if (expression < 0, 0 expression) as newexpression
from/resident ....
and then work with the newexpression and you keep the origin field