MAXA function

This topic describes the formula syntax and usage of the MAXA function in the Data Quality Execute Formula transform.

Description

Returns the maximum value in a list of arguments, including numbers, text, and logical values.

Syntax

MAXA(value1,[value2],...)

The MAXA function has the following arguments

  • value1 Required. Value, column, or range to be evaluated.
  • value2, ... Optional. Subsequent values, columns, or ranges to be evaluated.

Notes

  • Arguments can be the following: numbers; column names, ranges, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.
  • Logical values and text representations of numbers in the list of arguments are counted.
  • If an argument is an range or reference, only values in that range or reference are used. Empty fields and text values are ignored.
  • Arguments that cannot be translated into numbers cause errors.
  • Boolean arguments that contain true evaluate as 1. Boolean arguments that contain false evaluate as 0.
  • If the arguments contain no values, MAXA returns 0 (zero).
  • If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAX function.

Example

Table 1. Data
Col1 Col2 Col3 Col4 Col5
0 0.2 0.3 0.4 true
Formula Description Result
MAXA([Col1]:[Col5]) The largest value in the range. Because the Boolean value true calculates to 1, it is the largest. 1