​​​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 |
|---|---|---|
| 1.1 | 1.1 is the smallest value. |
| -14.7 | -14.7 is the smallest value. |
| Returns the smallest values between the Metric ‘Expenses’ and another Metric ‘Threshold’. | |
| Returns the earliest date between the Metric |
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!