- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
expression function - maximum value [2016/09/14 18:19] |
expression function - maximum value [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Maximum Value (Expression Function) ====== | ||
+ | ===== Purpose ===== | ||
+ | The **Maximum Value** function (MAX_VALUE) takes inputs of any number of values, and returns the number with the largest value. | ||
+ | |||
+ | {{::max_value_initial.png?direct&600|}} | ||
+ | |||
+ | ===== Parameters ===== | ||
+ | The **Maximum 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 **Maximum 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 "31" and "32" and it is used in MAX_VALUE(${Contact - Age}) the result will be "31". If you want to compare all the values then you should use [[Expression Function - Maximum Field Value|MAX_FIELD]](${Contact - Age}) which would generate "32". | ||
+ | |||
+ | ===== Output ===== | ||
+ | |||
+ | The output of the **Maximum Value** function is a number that is the largest value found. | ||
+ | |||
+ | ===== Example ===== | ||
+ | |||
+ | For example MAX_VALUE(-20,-5,0,3) would result in 3. |