Description

Returns the smallest value among all given values. Data type can be numeric or date.

Syntax

MIN(Value1 [, Value2] [, Value3] …)

Arguments

Argument	Type	Dimensions	Description
Value1 (required)	Integer, Number, or Date	Any Dimensions	First value to compare.
Value2 (optional)	Integer, Number, or Date	No Dimension or Dimensions of argument Value1	Other value to compare.
Value3 (optional)	Integer, Number, or Date	No Dimension or Dimensions of argument Value1	Other value to compare.
This functions accepts any number of arguments of the same data type as the Value1

Returns

Type	Dimensions
Integer, Number, or Date	Dimensions of argument Value1

Examples

Formula	Result	Description
`MIN(5, 1.1, 3)`	1.1	1.1 is the smallest value.
`MIN(-14.7, 34)`	-14.7	-14.7 is the smallest value.
`MIN('Expenses', 'Threshold')`		Returns the smallest values between the Metric ‘Expenses’ and another Metric ‘Threshold’.
`Max('Start Date',DATE(2023,1,1))`		Returns the earliest date between the Metric `Start Date` and January 1st 2023, thus replacing any dates after January 1st 2023 with January 1st 2023

See also

Excel: MIN

Related articles: MAX

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!

MIN function (Time & Date)

See also

Product

Use Cases

Resources

Company

Follow