MAX
Last updated
Last updated
The MAX function returns the largest number in a set of values. Node references are also accepted as arguments.
MAX(value1, ...valueN?) - > number
| Arguments | Data type | Description |
|---|---|---|
Consider the below example with a node that has the demand for a particular product for 12 months.
To calculate the maximum demand, the following formula should be written in the [Maximum demand] node:
MAX([Demand].ALL_PERIODS)
We are including .ALL_PERIODS so that it will consider all the period values rather than one single period.
Maximum Demand
319
value1
Number, Node reference
The nodes or numbers for which you want to evaluate the largest value.
...valueN?
Number, Node Reference
Additional nodes or numbers for which you want to evaluate the largest value. This is an optional argument.
