Customize

Calculate Total of Fields in Table

Summary

Calculate the total value of the specified fields in the table.
You can reuse the result of the calculation in other Actions.

How to use

Parameters

Set Filed to Calculate, Target Field (Optional), and If no rows in the table.

Field to Calculate

Select the field in the table to calculate the sum. This parameter accepts the following field types:

  • Number
  • Calculated

The “Calculated” field type must be in numeric format. The “Calculated” field in Date, Time, and Date & time formats is not supported.

Target Field (Optional)

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.

  • Text
  • Number
  • Text area
  • Rich text

If no rows in the table

Select the action when there are no rows in the table. Based on the selection made, the value and result value for the action entered in the “Target Field” when no rows in the table 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

Restrictions

  • The “Field to Calculate” field in Date, Time, and Date & time formats is not supported.