The PRODUCT function multiplies multiple values together and returns the resulting value. It performs multiplication across all provided numbers or node references and is commonly used in calculations involving totals, scaling factors, or combined values.
Syntax
PRODUCT(value1,value2,...valueN)
Arguments
value1, value2, ... valueN: Numbers or node references to multiply.
Return value
Returns the product of the specified values.
Example
PRODUCT(UnitPrice,Units)
In this example, the Total Sales measure is created using the PRODUCT function, which returns the product of the values in Unit Price and Units.
