Consolidated Income Statement Task: Hide Zero Balances

To hide zero account balances, complete the following steps:

Select the column, and then select Highlight from the Conditional Formatting section on the Column tab.
In the Highlight window, perform the following steps:
- Enter 0 in the Value field.
- Click in the Color field, select the box for white on the Color Picker window, and then click OK.
- Click in the Background Color field, select the box for white on the Color Picker window, and then click OK.
Note: Do not select the white box that has an X in the box. The white color is not used in the statement output if you select that box.
Repeat Steps 1 and 2 for each column, including the percent of revenue and the percent of changes columns.
Click the Save icon to save your layout.

Caution: If you need to exit the BI Publisher Layout Editor, do not click the Sign Out icon or you will log out of the server. Instead, click the Close icon (the X in the upper right corner of the window) to exit the window.

After you complete the steps in this section, your layout will look like the following image:

Consolidated Income Statement: Hide Zero Balances in the Revenue Section