In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

AVitenson
5 - Atom

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?

1 REPLY 1
benakesh
12 - Quasar

Hi @AVitenson ,

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

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

benakesh_0-1573342382433.png

Labels
Top Solution Authors