SAP Knowledge Base Article - Public

2536902 - Results Rows Does Not Show Moving Average

Symptom

You have created a custom key figure and set Moving Average for Calculate Result As in the Local Calculation settings. In the key figure results, it shows 3 decimal numbers for each of the results, including the sub-total.

You want to show fewer decimal places for key figure result numbers.

Reproducing the Issue

  1. Go to Business Analytics Work Center
  2. Open the report
  3. Click on Go
  4. Click on Settings > Key Figures
  5. In the Key Figure Settings screen, jump to Specific tab
  6. For the key figure(s) you want to decrease decimals, set the value 0 for Decimal Places column
  7. Click on Ok

All key figures values show without decimal places, exceptionally for Result Rows which still shows 3 decimal places. 

Cause

The key figure setting to show decimal places does not apply to subtotals, when it has Moving Average applied as local calculation, it only applies to key figure value. However, the 3 decimal places is not set to other type of Calculation Result such as Total, it is a standard setting for Moving Average.

Resolution

The local calculation for the key figure with Local Calculation: Calculation Result As  Moving Average is the standard behavior to show 3 decimal places in subtotal (result row).

Keywords

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