Count Null cells in date column?

2 posts, 0 answers
  1. Keith
    Keith avatar
    1 posts
    Member since:
    Jan 2017

    Posted 21 Mar Link to this post

    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?
  2. Todor
    Admin
    Todor avatar
    175 posts

    Posted 23 Mar Link to this post

    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
Back to Top