SAP Knowledge Base Article - Public

2420616 - Cannot set the number formatting in a story for measure selection "All" in SAP Analytics Cloud


  • The number format in a story for measure selection "All" only applies to visible members in a table in SAP Analytics Cloud.
  • If you drill down on a dimension, the number format will not be applied to the expanded members.


  • SAP Analytics Cloud 

Reproducing the Issue

  1. Create a Story.
  2. Save the story.
  3. Go back in the story and change the number formatting, under Designer, for Measure Selection "All" and Display the measure as "Billions".
  4. Expand the hierarchy.
  5. The formatting is not applied to the lower level of the hierarchies.

    06-Jun-18 1-28-31 PM.png


  • This works as designed.
  • If you override the number formatting in the styling panel, it will only apply to the selected node / member.


  • In general it is possible to have different scalings or even different units for the different children in the account hierarchy. In such cases it is not possible or not desireable to apply the parent formating to the children nodes.
  • If you want this behaviour, you have to change the formatting manually for all the children.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating facility at the top right-hand corner of this article.
Thank you.


EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, number designer formatting , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , How To


SAP Analytics Cloud 1.0


06-Jun-18 1-28-31 PM.png