### 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