Min

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

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

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

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

Syntax

Min(List(values) or [field] of [list])

Min(List(1, 2, 5, 3)) =>Result: 1

Min(List(45s, 12s, 50s, 1m25s) =>Result: 12s

Min([Products.Price] of [Products]) => Result: the min Price-value of all products in the list [Products]

Min() =>Result: unknown

Parameters

Name	Type	Required	Description
values	list	☑️	list of values which can be either numbers, datetimes or durations.