Minimum Field Value (Expression Function)

Purpose

The Minimum Field Value function (MIN_FIELD) is used to find the smallest number value returned by a certain query.

Parameters

The Minimum Field Value function has one parameters:

Field Value

Allowed Inputs: field values

The parameter of the Minimum Field Value function are the field values to be examined. The input is a query built using the Query Builder to find field values on one or many record(s) in a table.

Output

The output of the Minimum Field Value function is the smallest number found by a query.

Example

If an Invoice record has 4 related Line Item records, and those records have values of -6, 8, 8, and 24 in the Quantity field, COUNT(${Line Item ~> Quantity}) would result in -6.

expression function - minimum field value.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024