Replacing "-" with 0 in the script

[ritvik4BI]

Hi All,

I have a Sales field. But several values in the field are written as "-", which basically means 0 value for Sales. Now I want to replace - with 0 in the backend. 

How to do this transformation in the script?

Regards.

[yassinemhadhbi · Accepted solution]

Godd morning,

you can use this expression

If(IsNull(Sales) or Sales='',0,Sales) as Sales