MAX(Products[Price]) : The highest of all values in the
Price column of the
Products table. Equivalent to
MAX(SELECT(Products[Price], TRUE)). See also
MAX([Discounts]): The highest of the items in the
Discounts column value, where
Discounts is of type
MAX(LIST(1, 2, 3)) returns
Highest from Select Values
Highest discount given to non-employees within the past month:
([Sale Date] > (
EOMONTH(TODAY(), -2) + DAY(TODAY())
SELECT(Sales[Discount Amt], ...)returns a list of values from the
Discount Amtcolumn from rows of the
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 a
Customercolumn value that refers to a customer record that indicates the customer is also an employee.
[Sale Date] > ...includes only those rows with a
Sale Datecolumn 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 of
MAX(1, 2, 3) : the arguments are not in list form. To fix, wrap them in
LIST() to construct a list:
MAX(LIST(1, 2, 3)).
MAX( some-list )
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 Li
st 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.
The highest value in