Consolidated Income Statement Task: Hide Zero Balances

To hide zero account balances, complete the following steps:

1. Select the column, and then select Highlight from the Conditional Formatting section on the Column tab.

2. 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.

3. Repeat Steps 1 and 2 for each column, including the percent of revenue and the percent of changes columns.

4. 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: