Functions Available in Expression Editor

On creating or editing expression different functions that are divided into the following categories can be used:

• Aggregation. Aggregation functions.

• Arithmetic. Arithmetic functions.

• Attribute-based access control. Functions to create an additional condition to check access on using attribute-based access control method.

NOTE. The category is available only on creating an additional condition for access check in the Create Condition dialog box.

• All Functions. All existing functions

• Totals. Functions for working with totals.

• Logical. Logical functions

• R Methods.  Functions that use R package on their calculation.

NOTE. Calculation of R methods is available, if Foresight Analytics Platform has connected R package. To get a detailed information, see the Connecting External Modules to Foresight Analytics Platform article.

• Transformations. Transformation functions.

• Forecasting. Forecasting functions.

• Other. Other functions.

• Working with Python. Function call in the Python language

• Regression. Regression functions.

• Smoothing. Smoothing functions.

• Text. Functions for working with strings.

• Custom Functions. Custom calculation practices.

NOTE. The category is available if custom functions are connected to the expression editor. For details see the Connecting Custom Functions section.

See also:

Creating Formulas and Expressions