Min

This function returns minimal value from specified columns/fields in specified table.

Syntax

Min("source","fieldName");

Function arguments

• source – (String) The source of data containing values to be compared. This can be table name (i.e. 'Invoices’), nested table name (i.e. 'Finances>Invoices’)
• fieldName – (String) The name of the column/field containing decimal values from which minimal value is to be retrieved.

Return value

This function returns Decimal. Returns minimal value from specified column/field in specified table.

Examples

Example 1: This will return minimal value from 'column3′ in 'table1′.

Min("table1", "column3");