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:

      FLOAT(COUNT([CALCULATED FIELD 1))

       

      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?

       

      Thanks!