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