Defining the sign for data entry pages and reports

Use the Define How Values Display in Reports section to specify the sign for displaying the values in data entry pages and reports. You can specify a different sign than the sign used to store the values.

Users specify data in data entry pages according to the sign defined in the Define How Values Display in Reports section. For example, if a data entry page displays expenses as positive numbers, the user specifies the values as positives. The sign is changed when the data is written back to the cube.

You can also define how financial variances display in reports. You can specify, by account type, how increases or decreases display. For example, specify whether the favorable variances display as positive numbers or negative numbers (by account type). The example balance sheet and profit and loss statement are adjusted to show how a report looks according to your selections.

As you make changes in the Define How Values Display in Reports section, the 2014 and 2015 columns (columns 1 and 2) in the Balance Sheet, and Profit and Loss Statement examples show the effect of your changes.

As you make changes to the Define How Variances Display in Reports section, the Change, % Change, and Comparison columns (columns 3, 4, and 5) in the Balance Sheet, and Profit and Loss Statement examples show the effect of your changes.