Specifies the array to work with.
| 1. |
The following example returns the maximum value in the array, 10. MAX([5, 10, 0,
-10, 0])
|
| 2. |
To avoid an error when you pass an empty array to this function, you could use the following expression. Note the example above is encapsulated in the following IF statement. IF(COUNT([5, 10,
0, -10, 0]) > 0, MAX([5, 10, 0, -10, 0]) , -1)
|
Specifies the array to work with.
Specifies the beginning of the subset of the source array.
Specifies the number of elements to include in the subset of the source array.
| 1. |
The following example calculates the maximum value in , the specified subset of the array. The function returns 5. MAX([5, -10, 0,
10, 0], 1, 3)
|
| 2. |
To avoid an error when you pass an empty array to this function, you could use the following expression. Note the example above is encapsulated in the following IF statement. IF(COUNT([5, -10,
0, 10, 0]) > 0, MAX([5, -10, 0, 10, 0], 1, 3) , -1)
|
Specifies the array to work with.
Specifies the expression to apply to each element of the source array.
| 1. |
The following example calculates the maximum value after squaring each element. The function returns 16. MAX([-1, -4, -1,
0, -1, -4], Item*Item)
|
| 2. |
To avoid an error when you pass an empty array to this function, you could use the following expression. Note the example above is encapsulated in the following IF statement. IF(COUNT([-1, -4,
-1, 0, -1, -4]) > 0, MAX([-1, -4, -1, 0, -1, -4], Item* Item) ,
-1)
|
Specifies the array to work with.
Specifies the beginning of the subset of the source array.
Specifies the number of elements to include in the subset of the source array.
Specifies the expression to apply to each element of the source array.
| 1. |
The following example returns the maximum value found in [-1, 0, -1, -4] after squaring each element. The function returns 16. MAX([-1, -6, -1,
0, -1, -4], 3, 4, Item*Item)
|
| 2. |
To avoid an error when you pass an empty array to this function, you could use the following expression. Note the example above is encapsulated in the following IF statement. IF(COUNT([-1, -6,
-1, 0, -1, -4]) > 0, MAX([-1, -6, -1, 0, -1, -4], 3, 4,
Item* Item) , -1)
|