maxc()

Function group	Execute on client	Platform(s)
List	NO	All

Syntax

maxc(listname,column[,ignore-nulls])

Description

Returns the maximum value for a list column specified by listname and column. maxc() can only be used with columns defined using variables so it cannot be used with lists defined from a SQL class

If you set ignore-nulls to 1, null values are ignored and not counted. If you omit this parameter or it evaluates to zero, nulls are treated as zero values and are counted.

Example

Calculate
 
lMax
 as 
maxc
(
lInventory
,
lQuantity
)

# returns the maximum value in the lQuantity column of lInventory