Min Function

Returns smallest value of a member field or expression across a collection.

Syntax 1

Min(collection, field)

Returns smallest value of a member field or expression across a collection.

Arguments

collection Collection - A collection.

field Field - The field to use to find the minimum.

Syntax 2

Min(collection, expression)

Returns smallest value of a member field or expression across a collection.

Arguments

collection Collection - A collection.

expression Expression - An expression that resolves to a value.

Syntax 3

Min(collection, field, filter)

Returns smallest value of a member field or expression across a collection.

Arguments

collection Collection - A collection.

field Field - The field to use to find the minimum.

filter FilterExpression - Filter criteria. Only collection members that match this criteria will be considered.

Syntax 4

Min(collection, expression, filter)

Returns smallest value of a member field or expression across a collection.

Arguments

collection Collection - A collection.

expression Expression - An expression that resolves to a value.

filter FilterExpression - Filter criteria. Only collection members that match this criteria will be considered.

Remarks

• Arguments after the collection argument are evaluated in the context of a collection member.

Example:

Min(Vehicles, BI_PD.Premium, Year=1999); // returns 2000