Description
Returns the smallest value among all given values. Data type be numeric or date.
Syntax
MIN(Value1 V, Value2] a, 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. |
|
| 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!
