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 |