- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
The PRODUCT function (PRODUCT) is used to multiply all the numbers together from multiple field values.
The Product function has one parameters:
Allowed Inputs: 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 values on one or many record(s) in a table.
The output of the Product function is a number representing a product of all the values found.
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).