4 Replies Latest reply on Aug 17, 2018 8:09 AM by Celeste Williams

# Calculating the number of blank cells

I have a calculation that determines the percentage of past due records by counting those rows that have a value in a column titled "Days Past Due", and divides that by the total number of records. We have decided to use the opposite metric, calculating the percentage of records that are NOT past due. I am struggling to figure out the right way to do it.  The original calculation was: (count([Days Past Due]))/(COUNT([Status])).  I tried using (count(ISNULL([Days Past Due]))/(COUNT([Status]))), but that returned values of 100% for everything.

I am on Tableau 2018.1. Any suggestions are appreciated!

• ###### 1. Re: Calculating the number of blank cells

Hi Celeste,

Please try this:

(count(if ISNULL([Days Past Due]) then 1 END)/(COUNT([Status])))

and let me know if the number returned is correct.

In your calculation, this calculation ISNULL([Days Past Due]) it returns back both the true and false values for every record. So that's why it is 100%.

Thanks,

Mavis

• ###### 2. Re: Calculating the number of blank cells

Will This not Work?

1-(count([Days Past Due]))/(COUNT([Status]))

• ###### 3. Re: Calculating the number of blank cells

That did it! Thanks, Mavis!

• ###### 4. Re: Calculating the number of blank cells

No, that didn't work.