Calculate the total value of the table rows' fields matching the specified conditions.
You can reuse the result of the calculation in other Actions.
Set Filed to Calculate, Field for Judgement, Criteria, Comparison Value, and Target Field (Optional), and If no rows meet the conditions.
Select the field in the table to calculate the sum. This parameter accepts the following field types:
The “Calculated” field type must be in numeric format. The “Calculated” field in Date, Time, and Date & time formats is not supported.
Select the the field to be used for condition evaluation from the fields in the table.
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 rows that meet the criteria. Based on the selection made, the value and result value for the action entered in the “Target Field” when no rows meet the conditions will be as follows:
| Parameter | Value to be set in the “Target Field” | Result value for the action |
|---|---|---|
| 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 rows in the table, it will be considered as “no rows matching the condition” and will result in the action selected here.