9 Replies Latest reply on Mar 7, 2016 10:26 PM by roland.latsch

    Tableau counting blank cells as values Count() not parsing nulls

    Cole Weinman

      Good afternoon,


      I am working with an .xls file that has uses a numerical metric between 0-10. However, sometimes the metric comes back as a blank.


      I am trying to aggregate the number of responses using this formula:



      To parse out null values

      ((COUNT(if [CALCULATION1]>=9 then 1 end))

      /COUNT([CALCULATION1])) *(100)


      Then, to get the count:



      However, my values are returning the blank fields as actual records, and the Count() function is not parsing out the blank fields.


      The report contains nonpublic information, so unfortunately I cannot attach it or the workbook. Any suggestions?