max
Description
Finds and returns the maximum value in the given column of the given dataset, or the max value in a series of numbers specified as arguments. When looking up the max in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, zero is returned.
Syntax
max( dataset, column OR number, number... )
Examples
For example, suppose you had a table with this dataset in it:
ProductCode |
Quantity |
Weight |
BAN_002 |
380 |
3.243 |
BAN_010 |
120 |
9.928 |
APL_000 |
125 |
1.287 |
FWL_220 |
322 |
7.889 |
max({Root Container.Table.data},
1
)
//would return 380
max(
0
,
10
/
2
,
3.14
)
//would return 5. You can also use this function to find the maximum in fixed series of numbers, specified as arguments
max({SomeValue},
0
)
//The following example is a great way to make sure a value never goes below zero: