MINOF function

Prev Next

​​​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!