MAX
The MAX function returns the largest number in a set of values. Node references are also accepted as arguments.
Syntax
MAX(value1, ...valueN?) - > number
Arguments
Arguments | Data type | Description |
---|---|---|
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. |
Example
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.
Result
Maximum Demand | 319 |
Last updated