You can use conditional column options to conditionally display or omit any column, depending on the relationship between the fiscal period for the column and the base period for the report.

For example, you can create a report that displays 12 different periods in which actual amounts are printed for the base period and for all prior periods. Also, the forecast amounts from an external spreadsheet are printed for all future periods in the report. This report dynamically derives the correct data for the actual amount, budget amount, or forecast amount, based on the base period for which the report is run.

To set up the example conditional report, complete the following steps:

1. Create a column definition with two columns for each period.

   The first column for a period contains actual amounts, and the second column for that period contains budget amounts.

2. For the actual column, in the Print Controlrow, enter the conditional operator P<=B.

3. For the budget column, in the Print Controlrow, enter the conditional operator P>B.

   Note
   When a column is suppressed by a conditional option, it is not included in any calculations.

You can also add a Totalcolumn that provides the totals all of the periods in the year. However, if you specify a range of columns in the total, Management Reporter includes only columns that actually appear in the report.