Consolidated Income Statement Case Study Task: Apply Column Masks

Apply column masks to the Current Period Actuals, Last Year Current Period Actuals, Year to Date Actual, and Last Year to Date Actual columns to format the decimal places in the account balances.

To apply column masks, complete the following steps:

1. Highlight the column cells to which to apply the mask.

   For example, select the cells in the Current Period Actuals column to apply a mask to the account balances in the Current Period Actuals column.

2. Open the Properties tab.

3. Click in the Formatting Mask field in the Data Formatting section.

4. Select the mask for the column selected.

   For example, select the Current Period Actuals Mask if you selected the Current Actuals column. Be sure to select the column mask for the column from the section that you are formatting. For example, if you are formatting the Revenue section, select the Current Period Actuals Mask from the Revenue section.

5. Repeat Steps 1-4 for each column.

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 task, your statement layout should look like the following image: