Chapter 15 Functions
15-7
MAX (Function) [Conforms to SLIM]
Function
Extracts the maximum value.
Format
MAX (<Expression>,<Expression>[,<Expression>…])
Explanation
This statement extracts the maximum value from an arbitrary number of
<Expression>’s.
The maximum number of expressions is 32.
Explanation: If the MIN function and the MAX function are used, the
minimum or maximum value of the designated
accumulation method or group fields can be obtained.
For example, this function can be used to check the
maximum and minimum shipping charges. If there is no
designation of the accumulation method, the whole
table becomes an object.
Related Terms
MIN
Example
DEFSNG lf1, lf2, lf3, lf4, lf5, lf6
DEFINT li1, li2, li3, li4, li5, li6
li1 = MAX(1, 2) 'Assigns the maximum value between (1, 2) to
'li1.
li2 = MAX(li3, li4, li5, li6) 'Assigns the maximum value among (li3, li4,
'li5, li6) to li2.
lf1 = MAX(lf2, lf3, lf4, lf5, lf6) 'Assigns the maximum value among (lf2, lf3,
'lf4, lf5, lf6) to lf1.
Comments to this Manuals