CHANGE

Syntax

CHANGE (Dimension, Data, {Count})

Description

The CHANGE function returns the difference between the value of Data for the member being calculated and the value of Data for Count members back. If Count is omitted, it is assumed to be 1.

Example

Suppose you wish to calculate the monthly and yearly change in a data cube called SALES. If SALES uses a dimension called MONTHS, use the following formula to calculate the MONTHLY_CHANGE data cube:

CHANGE(MONTHS, SALES)

Because the Count argument is omitted, the program assumes it to be 1. Consequently, the program calculates the change in SALES from the previous month to the month being calculated.

Calculate the YEARLY_CHANGE data cube by using 12 for the third argument:

CHANGE(MONTHS, SALES, 12)

This formula calculates the change in SALES from 12 months ago to the month being calculated.