2 Replies Latest reply on Sep 3, 2015 6:00 AM by mike mitchell

    For Tableau 9, when using Oracle database, data blank or null instead of zero

    mike mitchell

      When searching how to prevent NULL values as appearing as blank spaces (instead of 0s) when the data is NULL, I found the following solution but it does not work for me. I wondered if it is because I'm using Tableau 9.0 or if there is another way to solve this problem?  I also followed a proces that had me create another worksheet, etc. but the result was the same.

       

      IIF(ISNULL(COUNT([column_name] )), 0, COUNT([column_name] ))