Expression Examples

Conditional Operator

To use a conditional operator in the Expression Editor dialog box, it is necessary to enter the following string:

Iif(Condition: Boolean; V1: Variant; V2: Variant): Variant

For example, to set an expression for the Quarters level:

Iif(Name="I quarter 1990", "Period start date", "Name")

For an element with the "I quarter 1990" name, the "Start of settlement period" name is displayed; the other elements of this level have standard names.

NOTE. On creating a conditional operator, please remember that all the fields of the calendar dictionary (NAME, LEVEL, ORDER, and so on) are of the string type.

Unit

To use a function from a unit, in the expression editor, please specify:

For example, when you set the following expression for the Years level:

Module.MyFunc(NAME)

The MyFunc function is used from the unit with the Module identifier; the function receives the value of the NAME parameter.

The example of function:

Function MyFunc(Str: Variant): Variant;

Begin

Return "Year " + (Str As String);

End Function MyFunc;

For all names on the Years level, Year is added before standard names.