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