Calculate the total value of a specified field for retrieved records that meet a specified condition.
The calculated result can be used in another action.
Set Record, Field to Calculate, Condition Decision Field, Criteria and Comparison Value.
From the list of actions, select the action that retrieved the records to be calculated.
Select the field for which you want to calculate the total. The following field types are available:
You cannot include fields that are within a table.
The Calculated field must contain only numeric values. Date, time, and date-time formats are not supported.
From the fields in the app, select the field you want to use to determine the condition.
The following fields cannot be selected.
You cannot include fields that are within a table.
Choose a comparison method such as “equal to” or “greater than”.
Comparison Value sets the value to compare with the field value. The comparison value can be one of the following values:
If there are no records, the result will be empty. It will not be zero.
The Calculated field with the date, time, and date-time formats are not supported for “Field to Calcurlate”.