Description
Returns the largest value among all given values. Data type can be numeric or date.
Syntax
MAX(Value1 [, Value2] [, Value3] …)
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Value1 (required) | Integer, Number, or Date | Any Dimensions | First value to compare. |
Value2 (optional) | Integer, Number, or Date | No Dimension or Dimensions of argument Value1 | Other value to compare. |
Value3 (optional) | Integer, Number, or Date | No Dimension or Dimensions of argument Value1 | Other value to compare. |
This functions accepts any number of arguments of the same data type as the Value1 | |||
Returns
Type | Dimensions |
|---|---|
Integer, Number, or Date | Dimensions of argument Value1 |
Examples
Formula | Result | Description |
|---|---|---|
| 5 | 5 is the largest value. |
| 34 | 34 is the largest value. |
| Returns the largest value between the Metric | |
| Returns the latest date between the Metric |
See also
Excel: MAX
Related articles: MIN
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!