SAP Knowledge Base Article - Public

2595463 - Decimal places format displayed differently depending on the Calculation used

Symptom

Different decimal places formats are displayet when using "Add Calculation" and "Advanced Calculation" in Analysis for Office.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

Adding simple and advanced calculation on values on different formats regarding decimal places.

Cause

It all depends on how many significative digits you have after the decimal point in your key figure number. Every key figure has a default number of decimal places that will be displayed in Analysis for Office (AO) and once in an Excel sheet, it is possible to edit/set this number in "Measures > Decimal Places".

Whenever all the key figures that are part of a "Add Calculation" operation in AO are set to be displayed with the same decimal places number, the resulting calculation mantains this pattern. But if just one of them are displayed with a different number of decimal places, the resulting calculation will display its default value of 7 significant digits for this result. If any other than this one is desired, it has to be edited.


See the examples below:

1. A simple "Add Calculation" with equal decimal places for every value involved

SimplesAdd-Equal.png

2. A simple "Add Calculation" with at least one value with a different decimal places configuration

SimplesAdd-diff.png

3. An "Advanced Calculation" with equal decimal places for every value involved

AdvancedAdd-Equal.png

In case of "Advanced Calculation" operation, the result is always displayed using 7 significative digits in the key figures, regardless how they are currently displayed in AO.


In general, the "Add Calculation" only mantains the displayed decimal places format when all the parts have the same. If one differs, it considers safer to use a minimum of seven digits. "Advanced Calulation", in its turn, always displays 7 digits after the decimal point.

Resolution

This is a expected behavior as the system is working as designed.

Keywords

Add Calculation, Add Advanced Calculation, AO, difference, decimal, decimal places, number, format, adding, measures , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions