Set Aggregate Functions for Number Fields
Availability
- Aggregate functions are available for all pricing plans of Creator.
- 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.
To set number field properties:
- Navigate to the Design page.
- Click the Configure Fields for Web button. The Configure Fields window will appear.
- Select the respective number, currency, or decimal field.
- Enable one or more of the following field properties:
- Total - Provides the sum of the values in the column
- Average - Provides the average of the values in the column
- Min - Provides the minimum value in the column
- Max - Provides the maximum value in the column
- Click Close to go back to preview.
On accessing the application, you will find an icon at the bottom of the report page. Click the icon to view the aggregate values.
Related Topics
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Understand Aggregate Functions
This page is applicable only to list report. Availability Aggregate functions are available for all pricing plans of Creator. Only the super admin, admins, and developers can set and manage aggregate functions, while users can view the respective ...Limitations: Forms and Fields
To know more about forms, click here General The maximum size allowed for a multi-line and rich text field in a row is approximately 64 KB. Multi-column layouts are not supported in forms if the check-box/radio-button fields are added dynamically ...Create Serial Number for subform rows
Requirement Create serial numbers or auto-numbers for subform rows when a new row is added. Use Case In an employee management system, an employee can add up to five dependents. It will be easy for the employees if the dependents added in the subform ...Set Phone Number Field Properties
This page is applicable to all report types except pivot chart and pivot table. Select the phone number field in the fields section to define properties specific to it. This field allows you to directly connect to the number entered. When accessing ...Set expression
Set expression for formula field Refer to this page to learn about the Formula field's Expression Open the form builder. Select the required formula field. Navigate to the Field Properties pane on the right. Click the input box below Expression . The ...