Rebase (REB#)

This rebases a data series to 100. The base value corresponds to either a specified date, or to a specified statistical value. For example, the maximum value or average value.

Format

REB#(Expression,Parameter)

Where Parameter is either a specified date or a function code or a date parameter:

• A date. Actual dates are typed using the standard DD/MM/YY format or the displacement date formats.
• A function code. See Using function codes as arguments
• A date parameter. See Date Parameters

REB#(Expression)

If no Parameter is specified, the REB# default is to rebase to the start date of the display period.

REB#(Expression,TIME)

TIME parameter is enabled for rebase function.

Examples

REB#(BDCP....F,31/1/98)

This rebases the German consumer price index to 100 at January 1998.

REB#(BDCP....F)

This default format rebases the the German consumer price index to 100 at the start date of the display period.

REB#(BDCP....F,MAX)

This rebases the German consumer price index to 100 at the date of its maximum value over the display period.

REB#(USCONPRCF,TIME)

This rebases the United States consumer price index to 100 at the latest available data value.

Note This function can only rebase individual series. It cannot rebase composite expressions.