changing dash [-] to zero

[#1]

How do I change this calculated [-] to zero?

[Kushal_Chawda · Accepted solution]

= If (isnull(YourExpression),0,YourExpression)

[#3]

In presentation tab for missing and null symbol u replace - by zero.

[sunny_talwar]

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)

[Saravanan_Desingh]

Just a small update to stalwar1‌ recommendation..

Alt(YourExpression*1, 0)

A numeric filled string will also taken care by this...