Examples

To use the global variable specify the global variable identifier in the Formula 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 @ determine cube coordinate, towards which the offset is calculated. By default the lag is 1, so in each calculation point the previous value is obtained. Determine the required lag. Example:

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