Functions Available in Expression Editor

Name	Brief description
Collapse	The Collapse method aggregates variable values.
Interpolate	The Interpolate method disaggregates variable values.
InterpolateP	The InterpolateP method interpolates variable values according to a pattern.

Name	Brief description
Abs	The Abs method returns absolute value (modulus) of selected variable points.
AbsI	The AbsI method returns absolute value (modulus) of selected variable points, if this variable contains only integer values.
Average	The Average method returns average of selected variable points.
AverageI	The AverageI method returns the average of selected variable points, if this variable contains only integer values.
Cos	The Cos method returns cosine of selected variable points.
Division	The Division method returns a quotient of pointwise division of two variables.
Exp	The Exp method returns the result of raising the "e" number to the power, specified by variable point.
ExpX	The ExpX method returns the result of raising variable points to the specified power.
Fact	The Fact method returns a factorial of selected variable points.
Floor	The Floor method returns the result of rounding down variable points to a multiple of prescribed accuracy.
FloorI	The FloorI method returns the result of rounding down variable points to a multiple of prescribed accuracy. The variable must only contain integer values.
Int	The Int method rounds values of selected the variable down to the nearest integer.
Ln	The Ln method returns a natural logarithm of specified variable points.
Log	The Log method returns a logarithm of the specified variable points with specified basis.
Log10	The Log10 method returns a base-10 logarithm of specified variable points.
Max	The Max method returns the maximum value of variable points.
MaxI	The MaxI method returns the maximum value of variable points, if this variable contains only integer values.
Mean	The Mean method returns mean for the specified variable.
Median	The Median method returns the median for the specified variable.
Min	The Min method returns a minimum value of variable points.
MinI	The MinI method returns a minimum value of variable points, if this variable contains only integer values.
Mod_	The Mod_ method returns the remainder of the integer division of variable points values by a specified number.
Mode	The Mode method returns the mode of the specified variable.
Modulus	The Modulus method returns the remainder of an integer division of variable points values by a specified number.
Mult	The Mult method returns the product of the corresponding points for two or more variables.
Power	The Power method returns the result of raising variable points to the specified power.
PowerI	The PowerI method returns the result of raising variable points to the specified power. All variable points and the power must be integers.
Rand	The Rand method returns a random uniformly distributed number, greater or equal to 0 and less than 1.
RandBetween	The RandBetween method returns a random real number between two specified numbers.
RandBetweenI	The RandbetweenI method returns a random integer between two specified integers.
Remainder	The Remainder method returns the remainder of division of variable points values by a specified number.
Round	The Round method rounds variable points values.
RoundDown	The RoundDown method rounds down variable points values.
RoundUp	The RoundUp method rounds up variable points values.
Sin	The Sin method returns the sine of specified variable points.
Sqrt	The Sqrt method returns the square root of specified variable points.
StDv	The StDv method returns the standard deviation for the specified variable.
Subtract	The Subtract method returns the difference of corresponding points for two or more variables.
Tan	The Tan method returns the tangent of specified variable points.
Trunc	The Trunc method truncates variable points to a specified number of decimals.
Variance	The Variance method returns variance of the variable.

NOTE. In the Modeling and Forecasting unit it is prohibited to use the AbsI, FloorI, PowerI, RandBetweenI, MinI, MaxI functions in the models calculated in transformation problem.

Name	Brief description
SubTotal	The SubTotal method returns value of subtotal, that is, value of the total of dimension items by the item of the upper dimension.
Total	The Total property returns the total value.

On using the Total function consider the following:

• If the calculated element is located in columns and the function is set with the Column Totals parameter, or the calculated element is located in rows and the function is set with the Row Totals parameter:

• If the Total function is set for the current dimension item without specifying the particular item in the formula, and the appropriate total method is calculated for the table, the grand total will be calculated by this item.

• If a new calculated element was added, and a formula is not calculated for it where the total could be taken, value of the Total function by this calculated element will be empty. In order value of the Total function by the new element should not be empty, add transformation for the new calculated element so that the total can be calculated by it, and then add transformation with the total function.

• If another element is specified for the calculated element in the formula, the grand total will be calculated by the specified element.

• If the calculated element is located in columns and the function is set with the Row Totals parameter, or the calculated element is located in rows and the function is set with the Column Totals parameter, value of the calculated element will correspond to value of the grand total by rows or columns, respectively.

On using the SubTotal function consider the following:

• If the calculated element is located in columns and the function is set with the Column Totals parameter, or the calculated element is located in rows and the function is set with the Row Totals parameter:

• If the SubTotal function is set for the current dimension item without specifying the particular item in the formula, and the appropriate total method is calculated for the table, the subtotal is calculated by this item.

• If a new calculated element was added, and a formula is calculated for it where the total could be taken, value of the SubTotal function by this calculated element will be empty. In order value of the SubTotal function by the new item should not be empty, add transformation for the new calculated element so that the total can be calculated by it, and then add transformation with the total function.

• If the data table heading or sidehead contain several dimensions, the subtotal is calculated by the last dimension in the heading or sidehead.

• If another item is specified for the calculated element in the formula, the subtotal is calculated by the specified item.

• If the calculated element is located in columns and the function is set with the Row Totals parameter, or the calculated element is located in rows and the function is set with the Column Totals parameter, value of the calculated element will correspond to value of the subtotal by rows or columns, respectively.

If the total or subtotal by rows or columns is not calculated, the corresponding functions set in the formulas return empty value. For example, if a formula is set as SubTotal, but the Sum total by columns for the table is not calculated, this function returns empty value.

Name	Brief description
Iif	The Iif method provides conditional execution of operators.
Sign	The Sign method returns sign of specified variable points.
SignI	The SignI method returns sign of specified variable points, if this variable contains only integer values.

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

Name	Brief description
ArimaR	The ArimaR method models variable's values by means of the ARIMA method with the help of R package.
BpfR	The BpfR method models variable's values by means of the Baxter-King filter with the help of R package.
ExpSmoothR	The ExpsmoothR method transforms variable data by means of exponential smoothing with the help of R package.
HpfR	The HpfR method smoothes variable data by means of the Hodrick-Prescott filter with the help of R package.
MedianSmoothR	The MedianSmoothR method executes median smoothing of variable with the help of R package.
MovAvgR	The MovAvgR method transforms variable data by means of moving average filter with the help of R package.
OlsR	The OlsR method models variable data by means of linear regression (OLS estimation). Calculation is executed with the help of R package.
R	The R method transforms data by means of R package methods.
TslsR	The TslsR method models variable data by means of linear regression (instrumental variables estimation). Calculation is executed with the help of R package.

The category is available if user functions are connected to the expression editor. For details see the Connecting User Functions to Expression Editor section.

Name	Brief description
Cumulative	The Cumulative method transforms variable using selected accumulation method.
CumulativeYTD	The CumulativeYTD method transforms the variable using selected accumulation method to the beginning of a year.
Diff	The Diff method calculates increment of variable points in comparison with the previous period.
DiffX	The DiffX method calculates the increment of variable points in comparison with the specified period.
DiffY	The DiffY method calculates increment of variable points in comparison with the corresponding period of the previous year.
DLog	The DLog method calculates the increment of logarithm of variable points in comparison with the previous period.
DLogX	The DLogX method calculates the increment of logarithm of variable points in comparison with the specified period.
Fill	The Fill method calculates empty values of the variable using various methods.
Lag	The Lag method shifts the variable forward by the specified number of points in a time period.
Lead	The Lead method shifts the variable backwards by the specified number of points in a time period.
Level	The Level method applies the Level function to the specified variable.
Pch	The Pch method calculates the rate of change of variable points in comparison with the previous period.
PchA	The PchA method calculates the rate of change of variable points in comparison with the previous period with seasonal adjustment.
PchX	The PchX method calculates the rate of change of variable points in comparison with the specified period.
PchY	The PchY method calculates the rate of change of variable points in comparison with corresponding period of the previous year.
Ratio	The Ratio method calculates the rate of change of variable points.
Rebase	The Rebase method applies the Rebase function to the specified variable.
Splice	The Splice method splices variables.
SpliceP	The SpliceP method transforms the variable on the basis of spliced variables.
Sum	The Sum method returns the sum of corresponding points for two or more variables.
SumI	The SumI method returns the sum of corresponding points for two or more variables, if these variables contain only integer values.
SumSq	The SumSq method returns the sum of squares of corresponding points for two or more variables.
Truncate	The Truncate method truncates the variable in accordance with selected parameters.

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

Name	Brief description
Arima	The Arima method models variable values with the help of ARIMA method.
AutoTrend	The AutoTrend method selects optimal trend for variable in the specified period.
ExpSmooth	The ExpSmooth method transforms variable with the help of exponential smoothing.
Extrapolate	The Extrapolate method transforms variable using a trend with functional dependency estimation.
GreyForecast	The GreyForecast method models a variable using the Grey Forecast method.

Name	Brief description
Estimate	The Estimate method returns estimated value of a constant.
GetValueByDate	The GetValueByDate method returns series value for the specific date.
IsSeriesEmpty	The IsSeriesEmpty method returns whether a series is empty.
None	The None method returns whether a constant is not used.
Pi	The Pi method returns the Pi constant.

Name	Brief description
Invoke	The Invoke method is used to execute specified function from specified unit using the Python language.

For details about calling Python functions from Prognoz Platform 9 see the Calling Python Functions section.

Name	Brief description
Ecm	The Ecm method transforms variable using the error correction model.
Ols	The Ols method models a variable with the help of linear regression (OLS estimation).
Tsls	The Tsls method models a variable with the help of linear regression (instrumental variables estimation).

Name	Brief description
Bpf	The Bpf method models variable values with the help of the Baxter-King filter.
Hpf	The Hpf method smoothes a variable using the Hodrick-Prescott filter (smoothing parameter is lambda).
HpfP	The HpfP method smoothes a variable using the Hodrick-Prescott filter (smoothing parameter is power).
Lrxf	The Lrxf method models variable with the help of LRX filter.
MedianSmooth	The MedianSmooth method models a variable with the help of median smoothing.
MovAvg	The MovAvg method transforms a variable with the help of moving average.
X11	The X11 method performs seasonal decomposition and data adjustment.

Name	Brief description
ASCII	The ASCII method returns ASCII code for the first row character.
Char	The Char method returns the character encoded with the ASCII code.
Contains	The Contains method returns True if this string contains the specified substring.
EndsWith	The EndsWith method returns True if this string ends with the specified substring.
Find	The Find method returns index of the substring position in the string, or 0 if the substring is not found.
Left	The Left method returns the specified number of characters from the beginning of string.
Length	The Length property determines string length.
Lower	The Lower method returns the string, which contains lower-case characters.
LTrim	The LTrim method returns the string with deleted spaces at the beginning.
Max_	The Max_ method returns the maximum from a and b by means of character by character string comparison.
Mid	The Mid method returns the string starting with the position with the "start" index.
Min_	The Min_ method returns the minimum from a and b by means of character by character string comparison.
Replace	The Replace method returns the string, in which all substring instances are replaced with the other string.
Right	The Right method returns the specified number of characters from the string end.
RTrim	The RTrim method returns the string with deleted spaces at the end.
Space	The Space method returns the string consisting of the specified number of repeated spaces.
StartsWith	The StartsWith method returns True if this string starts with the specified substring.
Trim	The Trim method returns the string with deleted spaces at the beginning and at the end.
Upper	The Upper method returns the string, which contains upper-case characters.