Calculate the average value of the table rows' fields matching the specified conditions. You can reuse the result of the calculation in other Actions.
Set Field to Calculate, Field for Judgement, Criteria, Comparison value, Target Field (Optional), and If no records meet the conditions.
Open the list of Actions and select the Action you used to obtain the target records.
Select the field that will be used to calculate the average value. This parameter accepts the following field types:
Fields in tables cannot be selected.
The “Calculation” field type must be in numeric format. The “Calculated” field in Date, Time, and Date & time formats is not supported.
Select the field to be used for condition judgment from the app’s fields. Fields in tables cannot be specified.
Select a criteria from the options.
Enter the value to compare the field’s value. The parameter accepts the following inputs:
Use this parameter to set the results to another field. You can leave this parameter empty to use the calculation result in another action without setting it to any field.
This parameter accepts the following field types: Fields in tables cannot be selected.
Select the action when there are no records that meet the criteria. Based on the selection made, the value and result value for the action entered in the “Target Field” when no records meet the conditions will be as follows:
| Parameter Value | Value to be set in the “Target Field” | Action Result |
|---|---|---|
| Set nothing | Do not change the value of the field | undefined |
| Set blank | Clear the value | undefined |
| Set zero | 0 | 0 |
| Set NaN | NaN | NaN |
If there were no records as a result of the “Select Record Action”, it will be considered as “no records matching the criteria” and will result in the action selected here.
The calculation results will not be rounded. To round the results, use with another action, such as “[Round Off Field Value[.”
When calculating the average, the number of records serves as the denominator, and this count includes records where the value of the “Field to Calculate” is empty.