Creating Formulas and Expressions

Cross functional expression editor can be accessed from various Foresight Analytics Platform tools and is used to create expressions, formulas, conditions.

Expression editor application area

The example of expression editor:

Expression editor

The expression editor window title contains name of the element, for which the expression is set up.

To set up an expression:

  1. Create an expression. The expression is created in the expression area. An expression may use operands, functions, operators, numbers and parentheses. For details see the Inserting Operands and Inserting Functions and Operators sections.

  2. Select the data, by which the expression is calculated. If the expression must be calculated by all source data, skip this step.

  3. Set up expression calculation period.

  4. If a calculated element is created or edited, rename it on the name panel.

As a result, the expression is set up.

The expression is checked for correctness during its setup. Error text is displayed on the errors panel with specifying the position, in which the error occurred. To put the cursor to the place of error occurrence, click on the error panel.

Expression appearance can also be set up. To do this, click the Settings button. The dialog box with the same name opens. For details see the Setting Up Expression Appearance section.

See also:

Value Editor Parameters | Editing Dimension