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
0
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
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.