---
title: mean()
slug: mean
docTags: 
createdAt: 2021-09-14T17:47:56.000Z
---

Returns the mean value of all the passed parameters, excluding `Nulls`.

### Syntax

`mean(value, value2, ...,)`

- `value` - the first value to be averaged.
- `value2` - the second value to be averaged.

**Return type:&#x20;**[Number](docId\:ucI5tCTfVBhonEJ6ZQijg) , [Percent](docId\:FbN7bFaHlFPV4f1C53DxA) , [Money](docId:_kS5D2xbfoR9d8WfRIVnY).

### Sample usage

`mean(2, 10)` returns `6`.

### Supported data types

| **Input type**                             | **Return type**                          | **Logic**                                                                                          |
| ------------------------------------------ | ---------------------------------------- | -------------------------------------------------------------------------------------------------- |
| ****[Number](docId\:ucI5tCTfVBhonEJ6ZQijg) | [Number](docId\:ucI5tCTfVBhonEJ6ZQijg)   | If a set of Number values is passed, the mean of the values will be returned as a Number value.    |
| [Percent](docId\:FbN7bFaHlFPV4f1C53DxA)    | [Percent](docId\:FbN7bFaHlFPV4f1C53DxA)  | If a set of Percent values is passed, the mean of the values will be returned as a Percent value.  |
| [Money](docId:_kS5D2xbfoR9d8WfRIVnY)       | [Money](docId:_kS5D2xbfoR9d8WfRIVnY)     | If a set of Money values is passed, the mean of the values will be returned as a Money value.      |
| *Unsupported data types*                   | **[Null](docId\:N9trVqonnBknqL9DrNBP6)   | Unsupported data types return `Null`.                                                              |

