# Differences

This shows you the differences between two versions of the page.

 — expression function - minimum value [2016/09/14 14:19] (current) Line 1: Line 1: + ====== Minimum Value (Expression Function) ====== + ===== Purpose ===== + The **Minimum Value** function (MIN_VALUE) takes inputs of any number of values, and returns the number with the smallest value. + + {{::​min_value_initial.png?​direct&​600|}} + + ===== Parameters ===== + The **Minimum Value** function has an unlimited number of parameters: + + ==== Values ==== + + Allowed Inputs: [[Field|field]] value or numbers + + The builder can enter as many inputs into the **Minimum Value** function as they want. Either use the use the [[Query Builder]] to choose a field that contains a number or use type a value to enter a number. When using the wizard to build the function after each new value is entered a new blank option will allow the builder to keep adding more values. ​ When using a query to find a field value if more than one value is found then only the first value is used.  So if you have a query that searches for Contact records and it would find the values "​34"​ and "​32"​ and it is used in MIN_VALUE(\${Contact - Age}) the result will be "​34"​. ​ If you want to compare all the values then you should use [[Expression Function - Minimum Field Value|MIN_FIELD]](\${Contact - Age}) which would generate "​32"​. + + ===== Output ===== + + The output of the **Minimum Value** function is a number that is the smallest value found. + + ===== Example ===== + + For example MIN_VALUE(-20,​-5,​0,​3) would result in -20.
expression function - minimum value.txt ยท Last modified: 2016/09/14 14:19 (external edit)