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
- Go to the Business Analytics work center.
- Go to the Design Reports view.
- 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