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!