This is a migrated thread and some comments may be shown as answers.

Count Null cells in date column?

1 Answer 176 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Keith
Top achievements
Rank 1
Keith asked on 21 Mar 2018, 03:17 PM
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?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 23 Mar 2018, 03:54 PM
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
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
Tags
Report Designer (standalone)
Asked by
Keith
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or