Aggregation Functions

Aggregation Functions

Article Type: How-To Audience: Developers, App Admins Module: How To

Numeric aggregation functions available in JSONata expressions throughout the Fuuz platform.

$sum()

Signature: $sum(array)

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

• $sum([5,1,3,7,4]) => 20

$max()

Signature: $max(array)

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

• $max([5,1,3,7,4]) => 7

$min()

Signature: $min(array)

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

• $min([5,1,3,7,4]) => 1

$average()

Signature: $average(array)

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

• $average([5,1,3,7,4]) => 4

See Also

• Array-Functions-How-To
• Boolean-Functions
• Comparison-Operators
• Custom-Fuuz-Only-JSONata-Library
• Jsonata-Tutorial

---

Source: support.fuuz.com