How to replace null values in a column with "0"

[Palaniyappan (Palaniyappan P)]

Fine
Try like this (it might have a space in it)
Convert.ToDouble(retValue.Replace(“-”,“”).ToString.Trim.Replace(" “,”").ToString)

Cheers @AryanSingh

[AryanSingh]

@Palaniyappan

Convert.ToDouble(retValue.Replace(“-”,“”).ToString.Trim.Replace(" “,”").ToString)

will it give an error if there value is negative but does not has space in between like 0.01 or 0.02??

@Palaniyappan

[Palaniyappan (Palaniyappan P)]

it looks like we have this kind of value

is that condition used buddy
Convert.ToDouble(retValue.Replace(“-”,“”).ToString.Trim.Replace(" “,”").ToString)

Cheers @AryanSingh

[AryanSingh]

@Palaniyappan

Yes, Please check the screenshot. Already changed!

[AryanSingh]

still same issue!

@Palaniyappan

[Palaniyappan (Palaniyappan P)]

I hope this should work
If possible can you share the workflow altogether in a zipped folder
Cheers @AryanSingh