Returns the lowest value in a list. If
list is an empty list of values, returns 0.
MIN(Products[Price]) returns the lowest of all values in the
Price column of the
Products table. Equivalent to
MIN(SELECT(Products[Price], TRUE)). See also:
MIN([Discounts]) returns the lowest of the items in the
Discounts column value, where
Discounts is of type
MIN(LIST(1, 2, 3)) returns
Lowest from Select Values
Lowest sale price to non-employees within the past six months:
MIN( SELECT( Sales[Sale Price], AND( ISNOTBLANK([Sale Price]), NOT([Customer].[Is Employee?]), ([Sale Date] > ( EOMONTH(TODAY(), -7) + DAY(TODAY()) )) ) ) )
SELECT(Sales[Sale Price], ...)returns a list of values from the
Sale Pricecolumn from rows of the
AND(..., ..., ...)limits the values returned to only those from rows that match all of the given conditions.
ISNOTBLANK([Sale Price])includes only rows with a non-blank
Sale Pricecolumn value.
NOT([Customer].[Is Employee?])excludes rows with a
Customercolumn value that refers to a customer record that indicates the customer is also an employee.
[Sale Date] > ...includes only rows with a
Sale Datecolumn value later than the computed date.
EOMONTH(TODAY(), -7) + DAY(TODAY()computes the date for six month ago today.
MIN(...)returns the lowest value in the select list of
MIN(1, 2, 3) In this example, the arguments are not in list form. To fix, wrap them in
LIST() to construct a list:
MIN(LIST(1, 2, 3)).
list- List of any numeric or any temporal type (but not a mix of both).
AppSheet must be given enough context to determine what type of values
list contains, that its contents are or will be a 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.