Ratio

Syntax

Ratio(Input: ITimeSeries,
     Period: MsInversionLag,
     PeriodNumber: Integer)

Parameters

Input. Output variable

Period. Period, relative to which the growth coefficient is calculated. Optional parameter. By default the parameter is set to MsInversionLag.PrecidingValue - previous period.

PeriodNumber. Period lag. Optional parameter. Minimum value and default value of the parameter is 1.

Description

It calculates the growth rate of variable points.

Example

Formula Result Application
= Ratio({Brazil|BCA}, MsInversionLag.PrecidingYear)

For the Brazil|BCA factor the growth coefficient of observation values to the corresponding period of previous year.

It can be used in formulas of calculated series of time series database and model formulas of modeling container that is a child of the time series database.
= Ratio(X1,MsInversionLag.PrecidingValue,2)

For the X1 factor the growth coefficient of point values to period is calculated, shifted from the current by two points.

It can be used in model formulas of modeling container.

See also:

Functions Available in Expression Editor │ TransformationsIModelling.Ratio