Skip Headers
Previous
Previous
 
Next
Next

Multiplication

Multiplies the values of two measures.

Template

Multiply measure measure (...) by measure measure (...).

Example

This calculated measure computes extended costs by multiplying the number of units sold (UNITS) by the cost per unit (UNIT_COST).

Calculation

Multiply measure UNITS (...) by measure UNIT_COST (...).

OLAP Expression Syntax

UNITS_CUBE.UNITS * PRICE_CUBE.UNIT_COST

Query Results

The Extended Cost column shows the cost of all units sold of the various personal computers.

Product              Units     Cost  Extended Cost
-------------------- ----- -------- --------------
Envoy Ambassador      2252  2663.79     5998855.08
Envoy Executive       2537  2643.68     6707016.16
Envoy Standard        3575  1737.43     6211312.25
Sentinel Financial   30909  1657.98     51246503.8
Sentinel Multimedia  7868   1813.14     14265785.5
Sentinel Standard    7452    1409.7     10505084.4