This page is applicable only to list report.

Availability

1. Aggregate functions are available for all pricing plans of Creator.
2. Only the super admin, admins, and developers can set and manage aggregate functions, while users can view the respective aggregate values in the live mode of the application.
   

• Minimum: The minimum value out of all the values in the number field type across records in the report.
• Maximum:  The maximum value out of all the values in the number field type across records in the report.
• Total: The sum of all the values in the number field type across records in the report.
• Average: The average of the values in the number field type across records in the report.

For instance, you have an Monthly Invoice report for your firm. It displays data on the products sold, date of selling, quantity, and price. Using the values in the quantity field, you can view the total number of products sold. And with the price field, you can view the total income made and the average income.

To view the aggregate values, you need to click the Show Summary at the bottom, right corner of the report. The values appear in a pop-up window. You can hide the window, once it's purpose is served.

Related Topics

1. Set aggregate functions for number fields