MicroStrategy ONE

Product

Multiplies all values in a list. This is a group-value function.

Syntax

Product<FactID>(Argument)

Where

  • Argument is an attribute, fact, or metric representing a list of numbers.
  • FactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.

Example

Given a value list containing the values (1,2,3,4), the product calculates as 1*2*3*4 = 24.