Example: Use of Variables

In a two-axis structure, you want the rows to contain three fiscal years and the columns to contain revenues and a revenue value taking inflation into account, based on fiscal 1996:

Profitability report

Revenue

Test

$FYT

XXX.XXX.XXX

XXX.XXX.XXX

$FYT

XXX.XXX.XXX

XXX.XXX.XXX

$FYT

XXX.XXX.XXX

XXX.XXX.XXX

$FYT

XXX.XXX.XXX

XXX.XXX.XXX

 

The form contains variables for characteristic values, text variables and formula variables:

For this you enter local variable &$FY in the first line of the dialog box for characteristic values. You then enter &$FY+1 and &$FY+2 in the second, third and fourth lines, respectively. You cannot see the variables in the rows of the form.

The text variable is to be replaced automatically in the report by the value of the fiscal year in the row. To do this, choose the menu option Extras  ® Variables ® Text ®  Maintain variable.. . In a series of dialog boxes, set variable $FYT to be replaced automatically with the value of the From field of the characteristic 'fiscal year' (beginning in position 1 with a length of 4 characters).

X001 / (1 + &$INFL) ** (&$FYN - 1994)

where X001 is the revenue column. You specify the inflation rate &$INFL. The variable &$FYN is replaced automatically by the fiscal year for the row.

Nothing more needs to be specified for the formula variable &$INFL. In a series of dialog boxes, you define the formula variable &$FYN to be replaced by the value in the From field of the characteristic Fiscal year (beginning in the first position with a length of 4 characters).

If you run the report with the value 0.04 for &$INFL and 1983 for &$FY, you will thus receive the following detail list:

09/01/1995 09:44:24

Revenue

Test

FY 1993

950.00

1,155.82

FY 1994

1,210.00

1,415.53

FY 1995

1,380.00

1,552.31

FY 1996

1,500.00

1,500.00