A .max()

Read(216) Label: non-null, maximum value,

Description:

Compute the maximum value of all the non-null members in a sequence.

Syntax:

A.max()

Equivalent to max(x1,…,xn)

Note:

The function computes the maximum value of all the non-null members in sequence A. Note that this function doesn’t apply to a sequence whose members are not of the same data type.

Parameters:

A

A sequence

Return value:

The maximum value of all members in sequence A

Example:

 

A

 

1

=[8,-6,1,3,5].max()

8

2

=["c","b","e","A"].max()

"e"

3

=["a",1].max()

Error message is displayed because the members are of different data types

4

=["a",null,"b"].max()

"b"

5

=max(8,-6,1,3,5)

8

Related functions:

A.sum()

A.avg()

A.min()

A.count()

A.max(x)