SOLVED
Replace a "0" (zero) with a blank cell when outputting data into an excel file
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AVitenson
5 - Atom
‎11-09-2019
02:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Help
- Output
1 REPLY 1
benakesh
12 - Quasar
‎11-09-2019
03:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AVitenson ,
I have used this formula to convert '0' values to nulls .
iif([Field1] = '0' , null(),[Field1])
