You are viewing the documentation for Blueriq 14. Documentation for other versions is available in our documentation directory.
PRODUCT
Returns the product of the values of a collection of numbers.
Syntax
PRODUCT ( collection )
Input
collection - A collection of number values.
Return types
number
integer
currency
percentage
Examples
Suppose the following data model.
Person.name | Person.score |
---|---|
“Kim” | 9 |
“Rick” | 8.5 |
“Bob” | 3 |
“John” | 7.5 |
“Mary” | 6 |
Expression | Value | Type |
---|---|---|
PRODUCT ( COLLECT Person.score FROM ALL Person ) | 10327.5000 | Number |
PRODUCT ( COLLECT Person.score FROM ALL Person WHERE ( Person.score < 8 ) ) | 135.0000 | Number |
PRODUCT ( [ 3.5 , 2.2 ] ) | 7.7000 | Number |
Overview
Content Tools