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?
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
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items