Scalar FunctionsDynamic / JSON Functions

array_sum

Sum the numeric elements of a dynamic array and return a real.

Null and non-numeric elements are skipped. An empty array or an array with no numeric elements yields null.

Syntax

array_sum(array)

Prop

Type

Returns: real

print array_sum(dynamic([1, 2, 3, 4, 5]))

print_0 (real)
15.0

array_split

Split a dynamic array at one or more indices.

bag_has_key

Return true if the property bag contains the given key.