Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I change this calculated [-] to zero?
= If (isnull(YourExpression),0,YourExpression)
= If (isnull(YourExpression),0,YourExpression)
In presentation tab for missing and null symbol u replace - by zero.
Or even this should work for true nulls
Alt(YourExpression, 0)
Incase they are not true nulls, you can try this:
If(Len(Trim(YourExpression)) > 0, YourExpression, 0)
Just a small update to stalwar1 recommendation..
Alt(YourExpression*1, 0)
A numeric filled string will also taken care by this...