Count in Total Row of Date Column

[Anonymous]

Silly question time I suspect.

I have a column of dates that I'd like to get a count of in the total row (only dates and null in the column).

Unfortunately the total row is formatted as a date as well. How can I get it tell me how many rows have a date in them?

Thank you!

[hector_munoz]

Hi Christine,

Try to put the following option in the expression desired:

Regards,

H

[Anonymous]

Tried that one. The problem is that the column is Date formatted.

[MK_QSL · Accepted solution]

IF(Dimensionality()=0,COUNT([Date Closed]),Date([Date Closed]))

or

IF(Dimensionality()=0,COUNT(DISTINCT [Date Closed]),Date([Date Closed]))

[Anonymous]

Perfect, thank you! The top one did the trick.

Never would have found this one on my own.