Notification

Please be advised that the Customer Support team does not provide troubleshooting services in your current display language. To contact Support team staff, please first switch to English or other supported languages (Spanish, Portuguese or Japanese). 

min_with_max

Returns the lowest value from a group of items that has the highest value for a specified attribute.

Note: This function is only available in Templates and can't be used in reporting.

Syntax

min_with_max(value, order_value)

Parameters

  • 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.
  • order_value: Any type of standard attribute or custom attribute (number, text or boolean), though typically you specify numeric or monetary attributes. The function selects all items that share the highest value of this attribute.

If you specify a text attribute, the function sorts by lexicographic order and selects items at the end of the sort list.

Learn more about custom columns in templates.

Example

An ad group that's scoped to the 'MyBrand' brand contains the following items:

BRAND TITLE PRICE DISCOUNT
MyBrand Red shoes $10.00 10%
MyBrand Yellow shoes $10.00 10%
MyBrand Blue shoes $10.00 5%
MyBrand Crew socks $5.00 20%
MyBrand Dress socks $5.00 20%
MyBrand Knee-high socks $5.00 15%

In an ad template,
[to_text(min_with_max(DISCOUNT, PRICE))]
does the following:

  1. Scans the PRICE column and finds the items that share the highest price.
    In this case, the function selects 'Red shoes', 'Yellow shoes' and 'Blue shoes' (which all specify a price of £10).
  2. Scans the DISCOUNT column for 'Red shoes', 'Yellow shoes' and 'Blue shoes' and returns the lowest value.

In this example, the function returns 5 ('Blue shoes' has a 5% discount).

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Main menu
5773084180965807417
true
Search Help Centre
true
true
true
true
true
5055977
false
false