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
2. A simple "Add Calculation" with at least one value with a different decimal places configuration
3. An "Advanced Calculation" with equal decimal places for every value involved
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