SAP Knowledge Base Article - Public

2699851 - Extension Field in a Report Displays Extra Zeros in Decimal Places

Symptom

You have added an extension field with zero decimal places to a report. When you execute the report the field shows 5 decimal places with zeroes.

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 view.
  3. Run a Report

Extension field in the report shows 5 decimal places.

Cause

The extension field is a key figure field and you have added it to the report as an attribute of a characteristic. The underlying data type of an extension field added as attribute has 5 decimal places. Hence it will show 5 decimal places for the field in the report. The key figure extension field added as a key figure will not show such a behavior.

Resolution

This is the designed system behavior.

Keywords

Extension field, Attribute, Decimals , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

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