Examples

To use the global variable specify the global variable identifier in the Formulas area, for example:

To use application functions from the module, specify the full path to the function in the following format: <module identifier>.<function name>.[(parameters values)]. For example:

To use the methods specify the full path to the method in the following format: <module name>.<class name>.<method name>. For example:

(See also: Classes, System Assembly Classes, IStatistics and MathFin).

Example of using the application methods:

To use Fore.NET functions in expressions, specify the <Fore.NET assembly identifier>.[<Namespace>].<Class name>.<Function name>. If the namespace is not defined, namespace of default .NET assembly is used. For example:

For mathematical methods specify only method name. For example:

Mathematical methods are implemented by the IMath interface.

To use the conditional operator, enter the string of the following structure: <condition> ? <value if the condition is True> : <value if the condition is False>.

Expression specified using the IIF conditional operator:

To use arithmetic operators of addition, subtraction, multiplication and division, click the +, -, - and / corresponding buttons. For example:

To use "equal", "not equal", "less than", "greater than", "less-than-or-equal-to", "greater-than-or-equal-to" signs and brackets, click the =, <>, <, >, <=, >=, () corresponding buttons. For example:

To get quotient of two values, click the DIV button; to get the remainder of division - the MOD button. For example:

,

where a1 and a2 are coordinates in the source cube.

To use "and" and "or" conjunctions, click the AND or OR corresponding button. For example:

,

where a1, a2 and a3 are coordinates in the source cube.

To use "not" conjunction, click the NOT button. For example:

,

where a1 is a coordinate in the source cube.

To use function returning value with moving by calendar dimension, click the LAGVAL function. In the inserted expression next to the @ character, set the dimension element from which shifted value will be be obtained. In the second parameter it is necessary to determine shift towards the current calculation point - lag. If the lag value is positive, the offset is backward by the calendar dimension. If the lag value is negative, the offset is toward by the calendar dimension. The offset is executed by the calendar level where the current calculation point is located. By default the lag is equal to 1. Example:

where Value is the fact dimension element in source-cube. The calculation result of the Change element values according to this formula: