Map and Table Calculation

MAX( ) function

Returns the maximum value.

Syntax

MAX(ValueColumn)
MAX(Value a, Value b)
MAX(Value a, Value b, Value c)

Input

ValueColumn	is a value column
Domain type:	any Value domain
Value a	is a value
Domain type:	any Value domain
Value b	is a value
Domain type:	any Value domain
Value c	is a value
Domain type:	any Value domain

Output

MAX returns:	a real value
Domain:	system domain Value

Notes:

The MAX(ValueColumn) function, i.e. 1 parameter only, can only be used in TabCalc.
To retrieve the maximum value of a single raster map, use the function MAPMAX.
The MAX function can also be performed through a dialog box, see Column Statistics.
When one of the input parameters is undefined, or when more input parameters are undefined, the output will also be undefined.

Tip:

When the definition symbol = is used, a dependent output map or dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output map/column has been calculated.

Usable in

MapCalc, TabCalc, Simple calculators

Examples

Pocket line calculator examples:

? MAX(3.8,8.1,1.34)	returns 8.10
? MAX(PIDIV4,NEG(2))	returns 0.7854
? MAX(Column1)	returns the maximum of column1 when used on the command line of a table window

MapCalc example:

OutMap = MAX(InMapA,InMapB)

InMapA

InMapB

OutMap

8	6	-4
4	-11	0
?	-7	3

8	7	-2
14	1	2
5	?	9

8	7	-2
14	1	2
?	?	9

TabCalc example:

OutCol1 = MAX(InColA)

OutCol2 = MAX(InColA,IncolB)

OutCol3 = IFUNDEF(InColA,MAX(InColA))

InColA	InColB	OutCol1	OutCol2	OutCol3
8	8	8	8	8
6	7	8	7	6
-4	-2	8	-2	-4
4	14	8	14	4
-11	1	8	1	-11
0	2	8	2	0
?	5	8	?	8
-7	?	8	?	-7
3	9	8	9	3

MIN	AVG	VAR	TTEST
SUM	STD	COV	CHISQUARE
CUM	STDEV	COVAR	Column Statistics
CNT	STDERR	CORR	AGGMAX