-
1. Re: Conditional formatting null cells
Janet Shen Jul 12, 2012 2:10 PM (in response to Cody Smith)Hi Cody,
To begin troubleshooting, let's first find out which cells are zeroes and which are nulls. Take Steps 1 and 2 from this article:
http://onlinehelp.tableausoftware.com/v7.0/pro/online/en-us/formatting_specific_nullvalues.html
Select "Show at Default Value" for Marks. If necessary, type in 0 for the Text field. Could you also attach an example workbook? Thanks!
-
2. Re: Conditional formatting null cells
Cody Smith Jul 12, 2012 2:20 PM (in response to Janet Shen)Attached is an example workbook.
-
Conditonal Formatting Nulls.twbx.zip 240.3 KB
-
-
3. Re: Conditional formatting null cells
Janet Shen Jul 12, 2012 2:35 PM (in response to Cody Smith)Thanks for posting the workbook! The blank cells are due to there being no rows of data that fit into certain grids on the table. There is a trick we can use to make them appear to contain "NULL" data. Try this formula for Calculation1:
IF ZN(LOOKUP(SUM([$ Sales]),0))>0 THEN 'Green' ELSE 'Red' END
LOOKUP() is a table calculation that looks at what is visible in the table. If it sees no data displayed for a cell, it will think the cell contains a NULL value.
ZN() will take that NULL and turn it into a zero. ZN() will let normal numbers pass through. I have attached an updated version of the workbook to demonstrate. Let me know if this helps!
-
Conditonal Formatting Nulls.twbx.zip 245.1 KB
-
-
4. Re: Conditional formatting null cells
Cody Smith Jul 12, 2012 4:46 PM (in response to Janet Shen)Thank you Janet. I've been trying to figure this out for 3 days. It worked perfectly!