Multiply

Multiply returns the product of two or more values. This function differs from the Product function (see Product), which returns the product of values in a single value list. The Multiply function can take multiple metrics as inputs and multiply the values of the metrics.

You can also construct these types of metrics using the times operator (see Times (*)) rather than the Multiply function.

Syntax

Multiply(Argument1, Argument2,..., ArgumentN)

Where:

The arguments must be metrics or constants.

Example

In the report shown below, the Unit Profit metric uses the formula Multiply([Unit Price],[Units Sold]) to return the revenue for each item. This report was created in the MicroStrategy Tutorial project.