SAP Knowledge Base Article - Public

2584678 - Excel Sum Function Does Not Work on Reports Downloaded in xlsx Format

Symptom

You have downloaded a report in xlsx Format. If you open it in Excel and select a column, the sum would not be shown in the toolbar below.

However if you download the same report in xml format and select the same column the sum will be shown.

EuGDPRCompliance.JPG

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports.
  3. Open the Report XYZ (XYZ represents the name of the report).
  4. Download Report to xlsx format.
  5. Open the report in Excel.
  6. Select a column with numerical values.

If the report is downloaded in xlsx format, the sum will not appear in the bottom toolbar.

Cause

When you download a report in xlsx format from the system, all the data in the report is anticipated as text in Excel. The sum function will work only on numerical fields not in text fields.

Resolution

There is a workaround in Excel. You can convert the Column text to numbers using Text to columns feature in Excel.

Keywords

Sum function, xlsx, report, download, text, excel, export to excel, values, key figure , 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 ; SAP Cloud for Customer core applications all versions