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 · Accepted solution]

@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!

[flying008]

Hi,@SH_94 

So easy of the formula for your need.

tonumber([Element])