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)