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

Aggregate Count Function

1 Answer 22 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Neil N
Top achievements
Rank 1
Veteran
Iron
Neil N asked on 04 Mar 2013, 03:04 AM
It seems the aggregate count function just counts the number of rows in a group, ignoring any field values.  Is this correct?  Is there a way to count the number of non-null values for a field (like how the SQL COUNT function works) without wiring up a custom aggregate?

1 Answer, 1 is accepted

Sort by
0
Antonio Stoilkov
Telerik team
answered on 07 Mar 2013, 07:29 AM
Hello Neil,

You are correct in your observations the Count aggregates count the number of records bound to the control but does not take into account the null values. You could use Custom aggregate or take a look at the help article below which describes how to calculate custom footer values.

Greetings,
Antonio Stoilkov
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Neil N
Top achievements
Rank 1
Veteran
Iron
Answers by
Antonio Stoilkov
Telerik team
Share this question
or