I've been trying to do a conditional format like in excel that will fill all NULL values with a solid red, but to no avail.
I tried using the follow calculated field:
IIF(ISNULL(SUM([$ Sales])),"Red","Green")
The "Green" part works, but it will not fill the NULL cells with red.
Attached is an example of what I'm trying to accomplish, except where all white areas will be red eventually.
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!
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!
Thank you Janet. I've been trying to figure this out for 3 days. It worked perfectly!