Reference Data
You have two possibilities for accessing reference data:

       1.      You make the field because of which the reference data of the data of the active planning filter differ as the field to be changed, for example, Version (0VERSION). You then write the operands as follows:

{ REVENUE, 002 } = { REVENUE, 001 }.

If there is no data available in version 002, then the internal data objects are made from the data from version 002 and also from 001. When executing the formula, data is created in version 002.

This syntax is intended for formulas that are to create new data from reference data.

       2.      You address reference data explicitly. To do so, you enter the name of the characteristic and the value in the operand.

{ REVENUE } = { REVENUE | 0VERSION = 001 }.

The formula will only run for records in version 002 as it cannot be determined from the formula how the records from version 001 are to be transformed into records from version 002. If there are no records available, the formula is not run. No records are created.

The syntax is intended for formulas that need reference data to evaluate existing data.

In the following example the data from version 002 is in the active planning filter. The formula is run for each record of the active filter. As there are no fields to be changed, the data objects consist of one record.