SAP Knowledge Base Article - Public

3614771 - Income Accounts '"INC" are displayed as positive values in stories despite being stored as negative in SAP Analytics Cloud.

Symptom

Income accounts defined with account type "INC" are displayed as positive values in reports, even though they are stored as negative values in the model.

Environment

SAP Analytics Cloud.

Reproducing the Issue

  1. Log in to SAP Analytics Cloud (SAC).

  2. Create a new model that includes an Account dimension.
  3. In the model, define account members and assign the account type "INC" to the income accounts.

  4. Upload negative values for these income accounts into the model.

  5. Create a new story based on the above model.

    >> Observe that the income accounts display positive values, despite the data being stored as negative in the model.

Cause

  • SAP Analytics Cloud automatically applies sign inversion for accounts with type "INC" during reporting.
  • If negative values are manually uploaded and the "Reverse the Sign of the Data Based on Account Type" option is also enabled during import, this can lead to a double inversion, causing income values to appear as positive in reports.

Resolution

To control how signs are displayed for "INC" accounts in reports, set the "Reverse the Sign of the Data Based on Account Type" option during import:

  • Enable the option if it is desired to reverse signs based on account type.
  • Disable the option if the source data already has the correct sign.

See Also

Attributes of an Account Dimension

Keywords

INC, Income accounts, negative value, positive, reverse, sign. , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0