MIN
Last updated
Last updated
The MIN function returns the smallest number in a set of values. Node references are also accepted as arguments.
MIN(value1, ...valueN?) - > number
| Arguments | Datatype | Description |
|---|---|---|
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.
Minimum Demand
136
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.
