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.