Transformations

When working with formulas one can use predefined functions listed in the table below:

Name Brief description

Cumulative

It transforms the variable using the specified cumulative method.

CumulativeYTD

It transforms the variable using the specified cumulative method to the beginning of the year.

Diff

It calculates the growth of variable points to the previous period.

DiffX

It calculates the growth of variable points to the specified period.

DiffY

It calculates the growth of variable points to the corresponding period of previous year.

DLog

It calculates the growth of logarithm of variable points to previous period.

DLogX

It calculates the growth of variable points logarithm to the specified period.

Fill

It enables the user to calculate the variable empty values using different methods.

Lag

It shifts the variable forward to the specified number of points in the time period.

Lead

It moves the series back to the specified number of points in the time period

Level

It smoothes data of the specified variable.

Pch

It calculates the rate of change of variable points to the previous period.

PchA

It calculates the rate of change of variable points to the previous period with seasonal adjustment.

PchX

It calculates the rate of change of variable points to the specified period.

PchY

It calculates the rate of change of variable points to the corresponding period of previous year.

Ratio

It calculates the growth rate of variable points.

Rebase

It rebases data of the specified variable from one frequency to another.

Splice

It splices variables.

SpliceP

It transforms the variable based on the spliced variables.

Sum

It returns the sum of corresponding points for two or more variables.

SumI

It returns the sum of corresponding points for two or more variables if they contains integer values only.

SumSq

It returns the sum of squares for corresponding points for two or more variables.

Truncate

It truncates the variable by the specified parameters.

NOTE. The SumI function cannot be used in the Modeling and Forecasting unit for the models calculated in transformation problem.

See also:

Functions Available in Expression Editor