Job Runner

Sum of Field of Records

Overview

This Do calculates the sum for a field within the records that you have retrieved.

You can reuse the result of the calculation in other Actions.

Usage

Parameters

Set Record and Field to Calculate.

Record

Select the Action from the list of Actions that retrieved the records to be calculated.

Field to Calculate

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

  • Number
  • Calculated

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.

Limitations

  • 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”.