MAX

Syntax

MAX (numeric_expression, numeric_expression, ...)

Description

Finds the largest value in the specified list of numbers.

Arguments

numeric_expression A number that can be converted to a Double64 number.

Returns

A numeric value in Double(64) format. A Double32 or Double64 data type represents a 32- or 64- double-byte floating-point number.

Examples

MAX (13.50, 56.75, 200.60)

Returns: 200.60

If your source data contains the following fields and data:

Transaction1 (13.50), Transaction2 (200.60), Transaction3 (56.75)

The following formula returns the same result:

MAX (MyEntity.Transaction1, MyEntity.Transaction2, MyEntity.Transaction3)

Related Topics

Data Conversion

Math Functions

AVERAGE

MIN