---
title: "Use the MAXOF Function to Return the Largest Value of a Block"
slug: "maxof-function"
description: "Learn to use the MAXOF function for to retrieve a Block's highest value in Pigment, with practical use case examples."
updated: 2025-05-28T10:24:26Z
published: 2025-08-22T12:00:18Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MAXOF function

## ​​​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 | ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/3ae7cf1d-1f19-490a-bcc8-b502837cf26e.png) 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](/v1/docs/minof-function), [SUMOF](/v1/docs/sumof-function)

> [!TIP]
> **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!

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>