Implement an Aggregation Footer in a Grid

Procedure

1. Create a grid using fast track, or convert the aggregated column to a template column.
2. From the smart panel, select Edit Template.
3. Select the footer template for your column.
4. Add a <div> control.
5. In the markup, replace the <div> with the following code.
   Average: <%= { act.Query("QueryName").AsQueryable().Select(Field("FieldName")). Average().ToString() } %>
   The field must be of type numeric.