You use relative headings to create dynamic column headings whose content changes depending on the period you specify when you run the report. You define relative headings by combining:
An ampersand (&) - Identifies the following token and number as a relative heading.
A token - Representing period of interest (POI), constant period of interest (CPOI), budget (BUDGET), encumbrance (ENCUMBRANCE), or currency (CURRENCY). The most often used token is POI.
A number - For POI relative headings, the number is a period offset. For budgets, encumbrances, currencies, and constant periods of interest the number is an associated control value.
Note: The number is expressed as a positive or negative value. For negative values, the minus sign (-) is required. For positive values, the plus sign (+) is optional.
Here are the relative headings you can use in a report:
&POI: Enter &POI (period of interest), followed by a number from -999 to +999 that refers to the relative period offset of your column. For example, enter &POI0 to display amounts for the period you specify at runtime, enter &POI-1to display amounts one period before the period you specify at runtime, and so on. Generally, the relative period offset you use to define a &POI heading corresponds to the period offset of the column.
&CPOI: Enter &CPOI (constant period of interest), followed by a number that refers to a constant period of interest control value representing a period number and relative year for that column. For example, enter &CPOI2 to refer to the constant period of interest as defined in control value number 2 to label the column with the name of the constant period selected.
&DOI: Enter &DOI (day of interest), followed by a number from -999 to +999 that refers to the relative offset of your column. For example, enter &DOI0 to display amounts for the effective date you specify at runtime, enter &DOI-1to display amounts one day before the effective date you specify at runtime, and so on. Generally, the relative offset you use to define a &DOI heading corresponds to the offset of the column.
&CDOI: For average amount types, enter &CDOI (constant day of interest), followed by a number that refers to a constant period of interest control value representing a period number and relative year for that column. It returns the last date of the period, as opposed to just the period name. Since average amount types in the constant period context references the period, quarter, or year average at the last day of the selected constant period, this token gives users more flexibility and provides clearer labels.
&BUDGET: Enter &BUDGET followed by a budget control value number to print the budget name assigned to the control value number when you define your report.
&ENCUMBRANCE: Enter &ENCUMBRANCE followed by an encumbrance control value number to print the encumbrance type assigned to the control value number when you define your report.
&CURRENCY: Enter &CURRENCY followed by a currency control value number to print the currency assigned to the control value number when you define your report.
If you define multiple relative column headings and enter text for a particular column set, and there is insufficient space to print all the values, FSG applies the following rules:
Relative column headings to the right override the one to the left.
Relative column headings override text.