Valuating Variables  

The standard system contains global variables for fiscal years, half-years, quarters and months. You use variables when defining forms. Variables represent the report parameters for a report. You determine their content when executing the report, and the system replaces them with values in different ways depending on the values you define.

The following examples show how variables are valuated in the FI G/L information system:

Example 1: Yearly comparison over two fiscal years

To achieve this you use the following variables in the first and second columns of your report:

Column 1

Column 2

&1FY

&1FY-1

 

On executing the report you enter the fiscal year " 1995 " under Change settings. The variables are then valuated as follows:

Column 1

Column 2

1995

1994

 

Example 2: Half-year comparison over two fiscal years

To achieve this you enter the following variables in the first and second columns of your report:

Column 1

Column 2

&2FY

&2FY-1

&2PF

&2PF

&2PT

&2PT

 

On executing the report you enter the fiscal year " 1995 " under Change settings and the second half of 1995 as the period. The variables are then valuated as follows:

Column 1

Column 2

1995

1994

007

007

016

016

 

Example 3: Quarterly comparison over two fiscal years

To achieve this you enter the following variables in the first and second columns of your report:

Column 1

Column 2

&3FY

&3FY-1

&3PF

&3PF

&3PT

&3PT

 

On executing the report you enter the fiscal year " 1995 " under Change settings and the third quarter of 1995 as the period. The variables are then valuated as follows:

Column 1

Column 2

1995

1994

007

007

009

009

 

If you enter the second quarter of 1995 as the period, the variables are valuated differently:

Column 1

Column 2

1995

1994

004

004

006

006

 

Example 4: Monthly comparison over two fiscal years

To achieve this you enter the following variables in the first and second columns of your report:

Column 1

Column 2

&4FY

&4FY-1

&4PE

&4PE

 

On executing the report you enter the fiscal year " 1995 " under Change settings and 10/1995 as the month or period. The variables are then valuated as follows:

Column 1

Column 2

1995

1994

10

10