min
function returns the lowest value of an attribute among a group of items.
For example, if a template is scoped to products with different prices, use this function to return the lowest price. If you’re not searching for the minimum value, you can use any(value)
instead.
Note: This function is only available in Templates and can’t be used in Reporting.
Syntax
min(value)
Parameter
value
: Any type of attribute or column (number, text, or boolean). The function returns the highest value of this attribute for one of the selected items.
Example
- The following function in an ad template returns the lowest price of all items in an ad group:
"Prices as low as " & [to_text(min(INVENTORY_ITEM_SALE_PRICE))]