# AVG function

## `AVG` function

| Function Name | Description | Usage | Input parameter | Return value |
|---|---|---|---|---|
| `AVG` | Calculates the numerical average of all the values in an array. | `AVG()` | N/A | Average of all the values in an array. The return value is of type `Double`. |

## Supported data type


The `AVG` function supports the following data types:

- Double array
- Integer array

## Example 1: Calculate the average of all the values in an integer array


**Sample data** : `$var1$ = {2,4,9,3}`


**Usage** : `$var1$.AVG()`
Calculate the average of values in var1.


**Output** : `4.5`

## Example 2: Calculate the average of all the values in a double array


**Sample data** : `$var1$ = {2.0,6.1,3.9}`


**Usage** : `$var1$.AVG()`
Calculate the average of values in var1.


**Output** : `4.0`

## Recommendation

- Learn how to add and configure a [Data Mapping task](https://docs-0cloud-0google-0com.linkedin.net.nz/application-integration/docs/configure-data-mapping-task.md.txt)