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

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

Cheers @AryanSingh

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

@Palaniyappan

it looks like we have this kind of value
image

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

Cheers @AryanSingh

@Palaniyappan

Yes, Please check the screenshot. Already changed!

1 Like

still same issue!

@Palaniyappan

1 Like

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.