Balance Sheet Case Study Task: Reverse the Sign of OVFS Account Balances Columns

Note: You can access an existing layout that was created for the One View Financial Statements feature only by using the Manage Layout option on the Work with Statement Definition form. If you exited the Layout Editor after you completed the last set of steps and need to re-access an existing layout, see Balance Sheet Case Study Task: Accessing an Existing Layout.

To reverse the sign of account balances, complete the following steps for the Current Actual, Month End, and Last Year End columns:

Select a column in the second table.
For example, select Current Actual.
Click the Define Custom Formula icon in the Formula section of the Column tab.
On the Function window, select Multiplication.
In the Function: Multiplication section, select the Multiplier option.
In the Parameter: Multiplier section, select the Constant Value option.
Enter -1 in the Value field, and then click OK.
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 task, your statement layout should look like the following image:

Balance Sheet by Business Unit: Sign Reversed for Liability Accounts