Calculation Wizard: Index calculation

The Calculation Type page accepts input for the following items for a index calculation:

Index

Click the drop down arrow and select an item from the list. This item represents a measure that is to be compared to a baseline value for the measure.

Starting at

If there is more than one time dimension, then a box appears to allow the selection of the proper time dimension. Otherwise the default time dimension is used.

for

Select a time dimension member.

Based on

Select an item from the Member column in the table for any entry that has a drop down arrow. This item provides further qualification for the baseline measure.

Formula Description

The formula for this calculation is:

(Current Member / Base Line Member)

Description

This formula is used to return the ratio of a measure's value as a percentage of a baseline value for the measure.

Example

An example of this calculation is:

Consumer Price Index (assuming baseline cost of goods is 1967) = (2001 Cost of Goods/1967 Cost of Goods)) * 100