ARRAY_SUM
Last updated
Last updated
This function calculates the sum of all non-null elements of the input. If there are no non-null elements, the function returns 0. The behavior is similar to the aggregate function but operates on an array.
array
numeric
A numeric array
The sum of all non-null elements of the input. If there are no non-null elements, the function returns 0. A primitive value input is considered to be an array with a single element.
array[1, 0.2, 30]
31.2
array[1, 0.2, 30]
31.2