SAP Knowledge Base Article - Public

3748085 - Comma displayed instead of Dot in report values; report fails to open without selections

Symptom

  • Getting "," displayed instead of "." in report values.
  • The report appears as "1,000" instead of using a period for decimal separation. 
  • Error message "Report Cannot be Opened / Failed to Open Report" appears when opening the report.



Environment

  • SAP Cloud Applications Studio
  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Go to the Shipment work center.
  2. Open any shipment.
  3. Scroll to the bottom and observe the Carton Weight field displayed as 1,000.
  4. Navigate to Business Analytics work center.
  5. Go to Design Data Sources.
  6. Open the data source Shipment_Datasource_ITEM (YXXXXXXX_X12234567).
  7. Check the field it shows a comma (.)

Cause

The affected report characteristic is a Text data type, not a Decimal/Key Figure. Text values are stored and displayed as entered, so punctuation such as "," or "." is not formatted by locale or user settings. 

Resolution

  1. Verify the field’s data type. If it is Text, numeric formatting rules do not apply.
  2. Enforce consistent input in processes/interfaces (always use "." or always use ","), or redesign the field to a Decimal/Key Figure type to enable numeric formatting.
  3. Review and adjust custom PDI/ABSL logic that writes the value so it is saved with the required separator (for example, ".") before it reaches persistence.

Keywords


Decimal separator, Comma instead of period, Text field formatting, Report cannot be opened, Shipment report, Decimal notation. , KBA , AP-RC-BDS-ANA , ByDesign Studio Analytics , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud Applications Studio all versions ; SAP Cloud for Customer core applications all versions