SAP Knowledge Base Article - Public

2971905 - Data point of calculated measure with 0 decimal place in percentage scale doesn't fall to the correct range of story-defined threshold in Bullet chart in SAP Analytics Cloud (SAC)

Symptom

  • Data point of calculated measure with 0 decimal place in percentage scale doesn't fall to the correct range of story-defined threshold in Bullet chart in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.18.2

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story with Bar/Column chart based on sample model [BestRunJuice_SampleModel].
  3. Create a new Calculated Measure with Formula as  "["BestRunJuice_SampleModel":Discount]/["BestRunJuice_SampleModel":Original_Sales_Price]".
    => One bar with data label 0.27 will appear in the chart.
  4. Format the calculated measure as below:
    • Option Use unit of underlying measures: off
    • Scale =  Percentage
    • Decimal Places = 0
      => The value shown in the data label is changed to 27%.
  5. Click Conditional Formatting menu to define Threshold on the calculated measure as below:
    • Green (OK): 80% - 100%
    • Orange (Warning): 30% - 80%
    • Red (Critical): 0% - 30%
  6. Show the story defined threshold in the bar chart.
    => The color of the bar is changed to red (Critical), which is expected.
  7. Change the chart type to Bullet.
    => The whole bar in the bullet chart appears in orange (Warning), which is unexpected.
    => If changing Decimal Places to other values like 1 or 2  in the Formatting dialog in step 4, the bullet bar will appears in three colors (red, orange, green) and the data point falls to red (critical) range correctly.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, bullet, Thresholds, Threshold, scale, percentage, percent, decimal, place, 0, zero , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0