When working with formulas one can use predefined functions listed in the table below:
Name | Brief description |
It transforms the variable using the specified cumulative method. | |
It transforms the variable using the specified cumulative method to the beginning of the year. | |
It calculates the growth of variable points to the previous period. | |
It calculates the growth of variable points to the specified period. | |
It calculates the growth of variable points to the corresponding period of previous year. | |
It calculates the growth of logarithm of variable points to previous period. | |
It calculates the growth of variable points logarithm to the specified period. | |
It enables the user to calculate the variable empty values using different methods. | |
It shifts the variable forward to the specified number of points in the time period. | |
It moves the series back to the specified number of points in the time period | |
It smoothes data of the specified variable. | |
It calculates the rate of change of variable points to the previous period. | |
It calculates the rate of change of variable points to the previous period with seasonal adjustment. | |
It calculates the rate of change of variable points to the specified period. | |
It calculates the rate of change of variable points to the corresponding period of previous year. | |
It calculates the growth rate of variable points. | |
It rebases data of the specified variable from one frequency to another. | |
It splices variables. | |
It transforms the variable based on the spliced variables. | |
It returns the sum of corresponding points for two or more variables. | |
It returns the sum of corresponding points for two or more variables if they contains integer values only. | |
It returns the sum of squares for corresponding points for two or more variables. | |
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: