MAX function

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

Description

Returns the maximum value in a set of values.

Syntax

MAX(number1, [number2], ...)

The MAX function has the following arguments

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

Notes

  • Arguments can be numbers, column references or ranges of columns.
  • If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
  • If the arguments contain no numbers, MAX returns 0 (zero).
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA function.

Example

Table 1. Data
Col1 Col2 Col3 Col4 Col5
77 23 20 7 2
Formula Description Result
MAX([Col1]:[Col5]) The maximum of values in range of five contiguous columns. 77
MAX([Col2]:[Col3],[Col5]) The maximum of values in range and a single column. 23
MAX([Col1]:[Col5],100) The maximum of values in range of five contiguous columns and a single value. 100