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

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.

SAP Analytics Cloud.

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.

• 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.

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.

Attributes of an Account Dimension

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