SAP Knowledge Base Article - Public

3417064 - Result Row Shows Wrong Values In The Report

Symptom

The result row is expected to show the summation or total value excluding the duplicate entries in the key figure column based on the characteristics added to the report view.

Environment

SAP Cloud for Customer 

Reproducing the Issue

  1. Go to Business Analytics Work Center.
  2. Navigate to Design Reports.
  3. Choose the affected report and Run the Report.
  4. Go to the View section and choose the affected characteristic.
  5. Click on Actions and choose Show Settings.
  6. Under General, in the result row drop down, choose Show and click Ok.
  7. Now Check the Result Row of the Key figure.

Cause

The result row is designed to show the sum of all the entries irrespective of duplicate entries. 

Resolution

This is designed system behavior.

Unless you define any local calculation settings in the key figure properties about how the key figure must be displayed, this will not change.

The behavior is the same in the reports as well as data sources.

See Also

2574052 - Custom Key Figure Shows Wrong Result - SAP for Me

Keywords

Result Row, Duplicate Entries, Summation, Sum, Total, Wrong value, Incorrect, Result, Key figure  , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Cloud for Customer core applications 2311