SAP Knowledge Base Article - Public

3372204 - Analysis of Office Decimal Places Not Rounded in Formula Bar


"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Formula bar displays more decimal places than its value cell in a crosstab.


SAP Analysis for Microsoft Office 2.8

Reproducing the Issue

Click on a cell in Analysis for Office crosstab and check the value displayed in the formula bar.


The value displayed in the formula bar is the base value of the cell, which comes from the BW backend without formatting. This value cannot be changed in Analysis for Office.

The data cells in the crosstab display the formatted value.

This is standard behavior. No solution is needed.


AO, Analysis for Excel, Analysis for Office, A4O, AFO, Digits, Points, Positions, Exact, Precise, Unrounded, Accurate, Specific , KBA , BI-RA-AO-XLA , Excel Addin , How To


SAP Analysis for Microsoft Office 2.8