minVal

Returns the minimum value in a set of numbers.

Empty or null values are ignored.

Parameters

X (number, list, or table region)
A number, list, or table region.
X (number, list, or table region)
Optional. Additional numbers, lists, or regions.

These examples cover the basic functionality:

ATL in Script	Result	Notes
`[[minVal(20, 40, 10, 30)]]`	10	The input set is four numbers.
`[[minVal((20, 40, 10, 30))]]`	10	The input set is a list of numbers.
`[[minVal(40, (15, 35, 65))]]`	15	The input set is one number and one list.
`[[minVal((20, 50, 90), (40, 30, 60))]]`	20	The input set is two lists.

More typically, the input is a table region or LIST variable.

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

You can search a single column.

ATL in Script	Result
`[[minVal(Orders)]]`	15
`[[minVal(salesRev)]]`	14,000

In a "Describe Row in Context" project, the column variables are OrdersColumn and SalesRevColumn.

You can also search a multi-column region.

ATL in Script	Result
`[[minVal(salesRev, otherRev)]]`	1,200
`[[minVal(COGS, otherExp)]]`	1,500

Use minVal with rows to interrogate specific rows.

ATL in Script	Result
`[[minVal(rows('Glasgow'))]]`	35
`[[minVal(rows('Inverness', 'Glasgow'))]]`	18