The Normal Balance cell controls the sign of the amounts in a row. To reverse the sign of a row, or if the normal balance of an account is a credit, enter a C in the Normal Balance cell for that row. Microsoft Office PerformancePoint 2007 Management Reporter reverses the sign on all credit balance accounts in that row. When Management Reporter converts these accounts, it removes the debit/credit characteristic from all amounts, which makes totaling very straightforward. For example, to calculate net income, you simply subtract expenses from income.
Totaled and calculated rows typically are not affected by a C code. The exception is that the XCR print control in the column definition reverses the sign of any row that contains a C in the Normal Balance column. This formatting is especially important when you want to show all unfavorable variances as negative amounts. If a totaled or calculated number displays the wrong sign, place a C in the Normal Balance cell for the row to reverse the sign. For more information about the column definition Print Control, see Print control.
To reverse the sign on the amounts in a report row, do the following:
Double-click a Normal Balance cell in an amount row of a row definition, and then select C.