Minimum Value (Expression Function)


The Minimum Value function (MIN_VALUE) takes inputs of any number of values, and returns the number with the smallest value.


The Minimum Value function has an unlimited number of parameters:


Allowed Inputs: 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 MIN_FIELD(${Contact - Age}) which would generate “32”.


The output of the Minimum Value function is a number that is the smallest value found.


For example MIN_VALUE(-20,-5,0,3) would result in -20.

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