SAP Knowledge Base Article - Public

3024019 - When exporting table to the CSV file using the scope 'Point of view;, formatting is not applied / applied incorrectly in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

When exporting table to the CSV file, formatting is not applied / applied incorrectly

Environment

SAP Analytics Cloud (Enterprise) 2021.3.5

Reproducing the Issue

  1. Login to SAC.
  2. Open the table which contains data in the monetary amount.
  3. On a PC, in the Control Panel, go to Clock and Region ->  Region -> Additional Settings and verify the separator formats.
  4. Open Profile preferences, to select number formatting (1 234,56) and currency position (1234 Million $). 
  5. Select the table.
  6. Select Export - File Type 'CSV; Scope 'All', Tick "Include number formatting'.
  7. Click OK.
  8. Observe that the data is exported in the format "35,496,674.22€" while expected format is "35 496 674,22 €".
  9. Select the table.
  10. Select Export - File Type 'CSV; Scope 'Point of view', Tick "Include number formatting'.
  11. Observe that the data is exported in the expected format "35 496 674,22 €".

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,, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, export, CVS, CSV, decimal, comma, point of view, all, format, formatting, incorrect, , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0