SAP Knowledge Base Article - Public

2584678 - Excel Sum Function Doesn't 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 Hybris 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

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions ; SAP HYBRIS C4C CORE all versions