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
- Go to Business Analytics Work Center
- Open the report
- Click on Go
- Click on Settings > Key Figures
- In the Key Figure Settings screen, jump to Specific tab
- For the key figure(s) you want to decrease decimals, set the value 0 for Decimal Places column
- 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