Syntax
AVERAGE(some-list)
Arguments
- some-list (list of any numeric type)
AppSheet must be given enough context to determine what type of values some-list contains, that its contents are or will be numeric. To that end, some-list must be one of the following: a column value of type List that contains numeric values; a column list (e.g., Products[Price]) for a column of a numeric type; or a constructed list (e.g., with LIST()) of a numeric type. See Examples below.
Return Value
Decimal: the computed average of the values of some-list
Examples
AVERAGE(Products[Price])
: The average of the all values in the Price column of the Products table. Equivalent to AVERAGE(SELECT(Products[Price], TRUE))
. See also SELECT().
AVERAGE([Discounts])
: The average of the all items in the Discounts column value, where Discounts is of type List for some numeric type.
AVERAGE(LIST(1, 2, 3))
: 2.00
AVERAGE(LIST(0) - LIST(0))
(a valid constructed list with a type but no items): 0.00
Potential Problems
AVERAGE(1, 2, 3)
: the arguments are not in list form. To fix, wrap them in LIST() to construct a list: AVERAGE(LIST(1, 2, 3))
.
AVERAGE(LIST())
: the constructed list has no items from which to determine type.