Sum

The Sum() function calculates the total value of a list of numbers or durations.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number or duration that is the total value of the given values.

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

Syntax

Sum(List(values) or [field] of [list])

Sum(List(1, 2, 5)) =>Result: 8

Sum([Products.Price] of [Products]) => Result: the summation of all Price-value of all products in the list [Products]

Sum() =>Result: unknown

Parameters

Name	Type	Required	Description
values	list	☑️	the list of values of which the sum is calculated. The values can be either numbers or durations.