In Centage, you can run reports to analyze the data from your budgets, including Ad Hoc reports, Income Statements, Balance Sheets, Variance reports, and Cash Flow reports.

You can customize each report to see only the information you need to see at a given time. For example, you can customize your calendar to see as long, short, or detailed a calendar view as you want (for example, only the quarterly amounts for 10 years, or the period amounts for three years).

One customization you can use in reports is an Ad Hoc Calculations column. An Ad Hoc Calculations column shows a running total or average of all the numbers in the view for that row, which helps you easily keep track of the total amount for each line item in your view.

You can check if an Account Group displays a total or average by visiting the Modeler, opening the Account Group Attribute page, and viewing the Total Column Calculation column:

• Note that for the Beginning and Ending Balance rows in the Cash Flow report, the Ad Hoc Calculations column is blank (because those rows already calculate a balance).

This document shows you, a Centage user, how to add an Ad Hoc Calculations column to your reports.

Locating the Reports Module

To add an Ad Hoc Calculations column to one of your Reports, open the Reports module, click on + New Report, and select one of the reports to view.

Please Note: This document uses the Income Statement report as an example.

The Income Statement page opens with a new, unedited Income Statement. Use this page to add an Ad Hoc Calculations column to your Income Statement report (focusing on the calendar view in this case).

Step 1: To customize your calendar settings, under Columns, select the More icon (  ) on the right side of the Time Dimension there (Default [Time] unless you are using an already-customized view with a different name).

Step 2: A Select Subsets pop-up appears.

Please Note: Private subsets, or views that only you can see, are marked with a Private icon ( ).

Step 3: Click Manage Subsets.

A Manage Subsets popup appears.

Step 4: Click on the Settings icon (  ) to choose whether to add a column to the table displaying Ad Hoc Calculations.

The Ad Hoc Calculations column calculates based on the lowest sub-level in your data. For example, if your calendar view is set to display Years, Quarters, and Periods, the Ad Hoc column would display the sum of the Period data.

To add an Ad Hoc Calculations column, after you click on the Settings icon (  ) in the Manage Subsets popup, a Subset Options popup appears. Click on the toggle switch to turn it to the ON position.

An Ad Hoc Calculation Title field appears. Enter the heading for the column which displays the Ad Hoc Calculations in this field and click Apply.

An Ad Hoc Calculation column with the title you entered appears in the table.