Returns the highest value in a list. If list
is an empty list of values, returns 0.
Sample usage
MAX(Products[Price])
returns the highest of all values in the Price
column of the Products
table. Equivalent to MAX(SELECT(Products[Price], TRUE))
. See also: SELECT()
MAX([Discounts])
returns the highest of the items in the Discounts
column value, where Discounts
is of type List
.
MAX(LIST(1, 2, 3))
returns Number
: 3
Highest from select values
Highest discount given to non-employees within the past month:
MAX(
SELECT(
Sales[Discount Amt],
AND(
NOT([Customer].[Is Employee?]),
([Sale Date] > (
EOMONTH(TODAY(), -2) + DAY(TODAY())
))
)
)
)
SELECT(Sales[Discount Amt], ...)
returns a list of values from theDiscount Amt
column from rows of theSales
table.AND(..., ...)
limits the values returned to only those from rows that match all of the given conditions.NOT([Customer].[Is Employee?])
excludes those rows with aCustomer
column value that refers to a customer record that indicates the customer is also an employee.[Sale Date] > ...
includes only those rows with aSale Date
column value later than the computed date.EOMONTH(TODAY(), -2) + DAY(TODAY())
computes the date for one month ago today.MAX(...)
returns the highest value in the select list ofDiscount Amt
values.
See also: AND()
, DAY()
, EOMONTH()
, NOT()
, SELECT()
, TODAY()
Common Problems
MAX(1, 2, 3)
In this example, the arguments are not in list form. To fix, wrap them in LIST()
to construct a list: MAX(LIST(1, 2, 3))
.
Syntax
MAX(list)
list
- List of any numeric or any temporal type (but not a mix of both).
Notes
AppSheet must be given enough context to determine what type of values list
contains, that its contents are or will be an appropriate type. To that end, list
must be one of the following: a column value of type List
that contains appropriate values; a column list (for example, Products[Price]
) for a column of an appropriate type; or a constructed list (for example, with LIST()
) of an appropriate type.