min
Returns the cell(s) containing the minimum value in a table region of numbers.
Use min to find all cells containing the minimum value. The function returns the cells along with the associated row names, which you can then interrogate with another function. See the examples for guidance.
DO NOT use this function to get the minimum value — for that, use minVal instead.
Note
Available in "Describe the Table" and "Describe Row in Context" projects only.
Parameters
REGION (table region)
The table region to search.
Notes
Typically the input is a single column, but you can enter a larger region if required.
All values in the region must be numbers.
Examples
Assume a "Describe the Table" project with this data:
Branch | Orders | salesRev | COGS | otherRev | otherExp | netProfit | |
|---|---|---|---|---|---|---|---|
Row 1 | Aberdeen | 15 | 14,000 | 8,000 | 2,000 | 1,500 | 6,500 |
Row 2 | Edinburgh | 35 | 33,000 | 19,000 | 2,000 | 3,500 | 12,500 |
Row 3 | Inverness | 18 | 16,000 | 8,250 | 1,200 | 1,500 | 7,450 |
Row 4 | Glasgow | 35 | 32,500 | 17,750 | 1,250 | 1,700 | 14,300 |
Row 5 | Dundee | 16 | 15,750 | 7,500 | 1,250 | 1,200 | 8,300 |
Row 6 | Perth | 15 | 14,500 | 8,000 | 1,000 | 1,400 | 6,100 |
The min function is rarely (if ever) used in isolation. Typically, it's combined with rowNames.
ATL in Script | Result |
|---|---|
| Aberdeen has the lowest sales total. |
| Perth is the least profitable branch. |
Note
In a Describe Row in Context" project, the column variables are salesRevColumn, netProfitColumn, etc.
Note that min returns all cells containing the minimum value.
ATL in Script | Result |
|---|---|
| Aberdeen and Perth received the least orders. |
IMPORTANT
To get the minimum value itself — not all cells containing that value — use minVal instead.
ATL in Script | Result |
|---|---|
| The lowest number of orders is 15. |
