website logo
Navigate through spaces
ChartHop documentation
⌘K
ChartHop Help Center
Getting around in ChartHop
ChartHop for Employees
Implementing ChartHop
ChartHop for Administrators
Carrot reference
ChartHop for Developers
Partners
Release notes
Resources
Docs powered by archbee 
website logo

mean()

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: Number , Percent , Money.

Sample usage

mean(2, 10) returns 6.

Supported data types

Input type

Return type

Logic

Number

Number

If a set of Number values is passed, the mean of the values will be returned as a Number value.

Percent

Percent

If a set of Percent values is passed, the mean of the values will be returned as a Percent value.

Money

Money

If a set of Money values is passed, the mean of the values will be returned as a Money value.

Unsupported data types

Null

Unsupported data types return Null.



Updated 03 May 2023
Did this page help you?
Yes
No
PREVIOUS
max()
NEXT
money()
Docs powered by archbee 
TABLE OF CONTENTS
Syntax
Sample usage
Supported data types