Changing Column Value Types for a Row

You can change the column values for Line and Continuation rows. For example, in a balance sheet report, you can show the year-to-date profit figure in the midst of balances.

The column change option converts a period or year-to-date column, to a balance, and vice versa. Quarter columns can be converted to balances, but the reverse does not apply.

Where this field is left blank, the column displays the figures originally selected in Financial Statement Layouts (FSL) or Financial Table Columns (FTC).

The following options are available:

• Balance - this option shows balance amounts in columns originally designated as year-to-date, period, or quarter columns in the statement layout. For example, PA-Period Actuals or YA-Year-to-Date Actuals, are converted to BA-Balance Actuals.
• Period - this option shows period amounts in a balance column.
• Year - this option shows year-to-date amounts in columns originally designated as balances. This excludes amounts from before the start of the year. For example, BA-Balance Actual is converted to YA-Year-to-Date Actual.