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
answered on 07 Mar 2013, 07:29 AM
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.
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.