SUM function

Description

Take an array and return the total values in the array.

If you specify something that does not represent a number, NaN (indicating that it is not a number) is returned.

If an element in the array is empty, its value is not added.

Usage Examples

In the following example, suppose the #1 action was to retrieve records, such as Retrieve All Records. Calculate the sum of the values in the Number column of the retrieved records in this #1 action.

= sum($1.Number)

In the following example, "" is not treated as a target, so the sum returns 12.

= sum([1, 2, "", 4, 5])

関連記事