Index Calculation

The Calculation Type panel 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.

Number Format -- Select one of the default number formats to use for this calculation or choose Options to specify another format.

Options -- Displays the Number Format dialog, in which you can specify a format for the calculation.

Formula Description

Formula

The formula for this calculation is:

(Current Member / Base Line Member)

Description

This formula is used to calculate 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