Transformations

When working with formulas, the user 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.