Count Null cells in date column?

[Keith]

I know Count is supposed to return a count of non-null items. But is there an easy way to return the number of null or empty cells in a column containing dates?

[Todor]

Hi Keith,

You can use an expression like:

= AllValues(Fields.date).Length - Count(Fields.date)

It gets the length of the array of all the values, and subtracts the non-null values, i.e. the result is the number of null entries.
For more information on the functions used in the above expression you can check the Aggregate functions article.

Regards,
Todor
Progress Telerik