# ARRAY\_SUM

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 `SUM` aggregate function but operates on an array.

## Syntax

```
ARRAY_SUM(array)
```

## Arguments

| Name | Type | Description | Default Value |
| --- | --- | --- | --- |
| array | numeric | A numeric array |  |

## Returns

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.

***

## Examples

| array | Output |
| --- | --- |
| array[1, 0.2, 30] | 31.2 |