Aggregation functions

On this page

$sum

Signature: $sum(array) Parameters:

Returns the arithmetic sum of an array of numbers. It is an error if the input array contains an item which isn’t a number. Example

Expression	Result
`$sum([5,1,3,7,4])`	`20`

Signature: $max(array) Parameters:

Returns the maximum number in an array of numbers. It is an error if the input array contains an item which isn’t a number. Example

Expression	Result
`$max([5,1,3,7,4])`	`7`

Signature: $min(array) Parameters:

Returns the minimum number in an array of numbers. It is an error if the input array contains an item which isn’t a number. Example

Expression	Result
`$min([5,1,3,7,4])`	`1`

Signature: $average(array) Parameters:

Returns the mean value of an array of numbers. It is an error if the input array contains an item which isn’t a number. Example

Expression	Result
`$average([5,1,3,7,4])`	`4`