- 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 field value [2016/09/14 18:19] |
expression function - maximum field value [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Maximum Field Value (Expression Function) ====== | ||
+ | ===== Purpose ===== | ||
+ | The **Maximum Field Value** function (MAX_FIELD) is used to find the largest number value returned by a certain query. | ||
+ | |||
+ | {{::max_field_initial.png?direct&600|}} | ||
+ | |||
+ | ===== Parameters ===== | ||
+ | The **Maximum Field Value** function has one parameters: | ||
+ | |||
+ | ==== Field Value ==== | ||
+ | |||
+ | Allowed Inputs: [[Field|field]] values | ||
+ | |||
+ | The parameter of the **Maximum 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 **Maximum Field Value** function is the largest 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 24. |