Follow the below steps to perform arithmetic operations such as sum, average, count, and more using the data stored in a Zoho Creator form:
i) Select a form whose data based on which this arithmetic operation needs to be configured.
Note: The
Select form dropdown lists all the forms in the application you are currently working on. To select a form from another application, click
Change App in the footer of the form dropdown. Select another application and click
Done to view all of its forms.

ii) Choose a numeric field from the Select field dropdown whose record data based on which the arithmetic operation will be configured.
Note: If there is only one numeric field available in that form, it will be auto-selected by default.
iii) Choose which records you want to evaluate for the arithmetic operation:
- All records - Evaluate all the records from the selected form
- Selected records - Evaluate a specific set of records that satisfy a criterion, to configure the operation.
If the display value of the panel is of the NUMBER datatype, you can configure the following properties as well:
i) Depending on the chosen operation, choose if you want to show the dynamic panel value as:
- Actual (Applicable for all operations) - The actual result of the operation. This is the default value.
- Percentage of total - Say the result of the arithmetic operation is 24 and the sum of all values recorded for that field is 240. Then the displayed percentage will be 10%.
(Applicable for Minimum, Maximum, Median) - Percentage of a number - Say the result of the arithmetic operation is 30 and the specified value under Numeric Value for the percentage is 120. Then the panel will display 25%.

(Applicable for Sum, Minimum, Maximum, Median, Average) - Fraction with the total in denominator - Say the result of the arithmetic operation is 24 and the sum of all values recorded for that field is 240. Then the displayed fraction will be 1/10.
(Applicable for Minimum, Maximum, Median)
ii) Choose a value under the Units dropdown if you want to display them next to the value in the live mode of the panel. The available options are None (default value), K (Thousand), M (Million), and B (Billion).
iii) Select the number of decimals that need to be displayed after the decimal point of the live mode value. The available options are 0, 1, 2 (default value), 3.
iv) Depending on the chosen number of decimals, select a punctuation format for the numerical values to be displayed in the live mode. If Default (Locale) is chosen, the format set on the browser in which the Creator account is logged in will be followed.
The configurations are auto-saved and will reflect in the live mode.
Count (counts field values) and Distinct Count (counts unique field values) operations
i) Select a form whose data based on which this arithmetic operation needs to be configured.
Note: The
Select form dropdown lists all the forms in the application you are currently working on. To select a form from another application, click
Change App in the footer of the form dropdown. Select another application and click
Done to view all of its forms.

iii) Choose which records you want to evaluate for the arithmetic operation:
- All records - Evaluate all the records from the selected form
- Selected records - Evaluate a specific set of records that satisfy a criterion, to configure the operation.
Note: Once you've configured the Zoho Creator arithmetic operation until this step, you can save this configuration as a panel preset. This panel preset can be reused within your Creator account wherever required.
Click Create Preset -> name and save the preset -> access the preset by choosing the Built-in Presets Display data when required.
iv) Choose if you want to show the dynamic panel value as:
- Actual (Applicable for Count and Distinct Count) - The actual result of the operation. This is the default value.
- Percentage of a number (Applicable for Distinct Count) - Say the result of the distinct count operation is 30 and the specified value under Numeric Value for the percentage is 120. Then the panel will display 25%.

- Percentage (Applicable for Count)
- Choose a field from the Field dropdown whose values need to be evaluated to calculate the percentage.

- Enter the field values which have to be counted and tallied against the total number of records to find the percentage.

- Fraction (Applicable for Count)
- Choose a field from the Field dropdown whose values need to be evaluated to calculate the percentage.

- Enter the field values which have to be counted and tallied against the total number of records to find the fraction.

v) Choose a value under the
Units dropdown to display it next to the dynamic data in the live mode of the panel. The available options are
None (default value),
K (Thousand),
M (Million), and
B (Billion).

vii) If you've chosen
Distinct Count and a numeric field for it, select the number of decimals that need to be displayed after the decimal point of the live mode value. The available options are
0,
1,
2 (default value),
3.

vii) Select a punctuation format for the numerical values to be displayed in the live mode. If Default (Locale) is chosen, the format set on the browser in which the Creator account is logged in will be followed.
The configurations are auto-saved and will reflect in the live mode.