SAP Knowledge Base Article - Public

2794852 - The bracket format not shown in excel report

Symptom

You download a report containing values in brackets to excel, you notice that the brackets are not shown in excel.

Environment

  • Business ByDesign
  • Cloud for Customer

Reproducing the Issue

  1. Go to the work center Business Analytics.
  2. Go to the view Design Reports.
  3. Open a report containing values in brackets.
  4. Download this report to excel.

You notice that the values are not shown in brackets.

Cause

The bracket format is not supported in excel add-in, as it removes the data aggregation behaviour of excel.

Resolution

This is the normal behaviour of the system.

Keywords

Bracket, value, Excel add-in, Excel report, Download to excel, AP-RC-ANA, parenthesis , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions