====== 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.

{{::min_field_initial.png?direct&600|}}

===== Parameters =====
The **Minimum Field Value** function has one parameters:

==== Field Value ====

Allowed Inputs: [[Field|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|field]] values on one or many [[record|record(s)]] in a [[Table|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.