- 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 - product [2016/09/14 18:19] |
expression function - product [2016/09/14 18:19] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Product (Expression Function) ====== | ||
| + | ===== Purpose ===== | ||
| + | The **PRODUCT** function (PRODUCT) is used to multiply all the numbers together from multiple field values. | ||
| + | |||
| + | {{::product_initial.png?direct&600|}} | ||
| + | ===== Parameters ===== | ||
| + | The **Product** function has one parameters: | ||
| + | |||
| + | ==== Field Values ==== | ||
| + | |||
| + | Allowed Inputs: [[Field|field]] values | ||
| + | |||
| + | The parameter of the **Product** function is the field values that contains the numbers that will be multiplied together. 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 **Product** function is a number representing a product of all the values found. | ||
| + | |||
| + | ===== Example ===== | ||
| + | |||
| + | If an Invoice record has 4 related Line Item records, and those records have values of -6, 0, 8, and 24 in the Quantity field, PRODUCT(${Line Item ~> Quantity}) would result in 0 (since -6 * 0 * 8 * 24 = 0). | ||
