Replace empty string with zero

SH_94

Dear community, 

I have the data as below whereby the element column is in V-string format and Sum_Quantity-IN is in double format. I would like to replace those empty field in the element column with zero. May i know how can i do that ? 

Many thanks for the help.

grazitti_sapna

@SH_94, you can use the formula tool and write the given formula.

If isnull(Element) or isempty(Element) then "0" else Element endif.

I hope this helps!

Thanks!