MIN

The MIN function returns the smallest number in a set of values. Node references are also accepted as arguments.

Syntax

MIN(value1, ...valueN?) - > number

Arguments

Arguments	Datatype	Description
value1	Number, Node reference	The nodes or numbers for which you want to get the smallest value.
valueN?	Number, Node reference	Additional nodes or numbers for which you want to get smallest value. This is an optional argument.

Example

Consider a node which has the demand for a particular product for 12 months.

To calculate the minimum demand, the formula should be written in the [Minimum Demand] node

MIN([Demand].ALL_PERIODS)

We are including .ALL_PERIODS so that it will consider all the period values rather than one single period.

Result

Minimum Demand

136