The Min() function calculates the lowest value of a list of numbers, datetimes or durations.

Syntax

Min(values)

Returns

A number, datetime or duration that is the lowest value of the given values.

Parameters

  • values – the list of values of which the lowest value is be calculated. The values can be either numbers, datetimes or durations.

Examples

Min([Products.Price] of [Products])
/* returns the lowest price of all the products in the list */

Min([Products.Price] of [Products] where [Products.Category] = 'Guitar')
/* returns the lowest price of all the guitars in the list */

Min([Appointments.Duration] of [Appointments])
/* returns the smallers duration of all the appointments in the list */

Min(List(1, 3, 6, 2))
/* returns 1 */

 +31 (0)20 240 21 20       

Videos and images courtesy of WEM Modeler. © 2019. WEM Modeler.
SitemapPrivacy - Terms - Company

 +31 (0)20 240 21 20       


Videos and images courtesy of WEM Modeler.
© 2019 WEM Modeler.
SitemapPrivacy - Terms - Company