Replace a "0" (zero) with a blank cell when outputting data into an excel file

AVitenson

Hello all,

Would appreciate your help. I'm trying to make "V_WString" type data field show as "blank" when outputting my data into Excel using the Render tool. I have set the data to null, but that shows as a "0" (zero) when outputted into Excel.

Any thoughts on how I can make these null values show as blank?

benakesh

Hi @AVitenson ,

I have  used this formula to convert '0' values to nulls . 

iif([Field1] = '0' , null(),[Field1])

render_blank.yxmd