Field Aggregation

It is often that you need to sum a field column and display the total at the bottom. CFMMaker makes it extremely easy.

For example, to set up the Field Average for the "Quantity" field, select "AVG" for the "Aggregate" column of this field in the Field Setup Page.

To set up the Field Total for the "ExtendedPrice" field, select "TOTAL" for the "Aggregate" column of the "ExtendedPrice" field.

In the generated script, the Field Aggregate will be shown in the footer of the "Order Details Extended" list page as follow: