MAX(arg1 [; ByEveryN])

The 'arg1' parameter must be an array.
ByEveryN is an optional argument - an integer constant, greater or equal to 1.

Returns the max value of the elements in the array 'arg1'.
If ByEveryN is supplied, then the function calculates the maximum for each group of N successive elements and the result is an array.

Calculates the max value of all the elements in the input array, or the max value of every N successive elements in the input array.

Example 1:

Expression: MAX( arg1 )

Result: 11

Example 2:

(max by every 2 elements)

Expression: MAX( arg1; 2 )

Windows Forms: All Examples\Data Manipulation\Functions\Average, Median, Min, Max