Relative Headings
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), 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, and currencies, 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-1 to 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.
&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-1 to 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.
&BUDGET: Enter &BUDGET followed by a control value number to print the budget name assigned to the control value number when you define your report.
&ENCUMBRANCE: Enter &ENCUMBRANCE followed by a 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 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.