Skip Headers
Previous
Previous
 
Next
Next

Division (Ratio)

Divides the values of one measure by the values of another measure.

Template

Divide measure measure (...) by measure measure (...).

Example

This calculated measure computes the ratio of Unit Price to Unit Cost.

Calculation

Divide measure UNIT_PRICE by measure UNIT_COST.

OLAP Expression Syntax

PRICE_CUBE.UNIT_PRICE / PRICE_CUBE.UNIT_COST

Query Results

The Ratio column shows the ratio of Price to Cost for various products.

Product              Price  Cost Ratio
-------------------- ----- ----- -----
Envoy Ambassador      2892  2664  1.09
Envoy Executive       2803  2644  1.06
Envoy Standard        1662  1737   .96
Sentinel Financial    1755  1658  1.06
Sentinel Multimedia   1770  1813   .98
Sentinel Standard     1552  1410   1.1