Formula Editor

The formula editor is used to create various formulas, expressions, and conditions required to create various objects and object parameters.

IMPORTANT. Formula editor is outdated, instead of it the expression editor is used by default. If you want to use formula editor, set the registry key HKEY_CURRENT_USER\Software\Foresight\Foresight Analytics Platform\10.0\UiTs\OldFormulaEditor to 1. By default the key is set to 0.

The expression, formula, or condition is displayed in this area. One can create an expression by typing required symbols and characters or by using the data area and appropriate buttons in the formula editor dialog box.

To create expressions, use:

Global variables. To do this in the formula field the global variable identifier should be specified.
Application functions. To use application functions from the module the path to the function should be specified in the following format: <module identifier>.<function name>.[(parameters values)].
Static methods of application and system classes (see also: Classes, System Assembly Classes, IStatistics and MathFin). To use methods, specify the full path to the method in the following format: <module name>.<class name>.<method name>.
Conditional operator. To use conditional operator, enter the following string: <condition> ? <value if condition is executed> : <value if condition is not executed>.

Buttons are used to insert mathematical functions and operations in a formula. To display the required operation sign or function in the formula pane, click the appropriate button.

Button	Description
+	Addition.
-	Subtraction.
*	Multiplication.
/	Division.
=	"Equals" sign.
<>	"Non equal" sign.
<	"Less than" sign.
>	"Greater than" sign.
<=	"Less or equal" sign.
>=	"Greater or equal" sign.
( )	Brackets.
DIV	Integer quotient.
MOD	Remainder of the division.
AND	And.
OR	Or.
NOT	Negation.

NOTE. On executing MOD and DIV operators for real data operands the result will be of the real data type.

The contents of the data area depends on from where the formula editor was opened. The data area may contain fields, attributes, and the parameters of the object (for a cube, table, or dictionary, and so on) or the additional functions that may be used to create expression. Double-click the required identifier to insert it into the formula area.