SAP Knowledge Base Article - Public

2803935 - Show Sign as "( )" does not work correctly for negative decimal numbers in SAP Analytics Cloud

Symptom

  • No "( )" sign is shown when using show sign as "( )" option for small negative decimal numbers in SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud 2019.9.4

Reproducing the Issue

  1. Create a table.
  2. Add some measures which has values between 0 and 1. (e.g.: -0,1 and -0,01)
  3. Go to the Styling panel.
  4. Select "Show Sign As" and the "( )" option.
  5. Notice, that the value:
    • is correct for -0,1, it shows "(0,1)"
    • is not correct for -0,01, it shows "0,0"

Cause

  • Decimal places for the measure are set for 1 in the Model.
  • Because of this the number -0,01 is 0 on Model and Story level.
  • This behavior is by design.

Resolution

  1. Go to the model.
  2. Change the decimal places for the measure to 2 ore more.
  3. Go back to the Story and notice that "0,0" is changed to (0,01).

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0