Description
Returns the highest value of a Block.
Syntax
MAXOF(Block)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Block (required) | Integer, Number or Date | Any | If Block is a Date, the function returns the latest date. For Number or Integer, it will return the highest value. |
Returns
| Type | Dimensions |
|---|---|
| Same Type as argument Block | No Dimension |
Examples
Employee is a Dimension List:
| Formula | Result | Description |
|---|---|---|
MAXOF(Employee.ID) | 3 |  3 is the highest number from this block. |
MAXOF(Employee.'Start date') | 12/14/2024 | Returns the latest start date from the block. |
See also
Related articles: MINOF, SUMOF
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!