Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
MIN – Select miniumum value
Overview
Returns the minimum of the arguments.
Syntax
MIN (n1, n2, n3)
MIN(10,15,25)
n1, n2, n3 | List of numerical values or arguments. Can have as many values/arguments as required. |
Examples
MIN(FIELDVAL(‘Price’),10)
Price | MIN |
5.00 | 5.00 |
10.00 | 10.00 |
15.00 | 10.00 |
17.50 | 10.00 |
In the example above MIN(FIELDVAL(‘Price’),10) looks at each value in the Price field and compares it to 10 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 so ‘10.00‘ is returned.
MIN(FIELDVAL(‘Price’),10,17)
Price | MIN |
5.00 | 5.00 |
10.00 | 10.00 |
15.00 | 10.00 |
17.50 | 10.00 |
In the example above MIN(FIELDVAL(‘Price’),10,17) looks at each value in the Price field and compares it to 10 and 17 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 or 17 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 but lower than 17 so ‘10.00‘ is returned.