SAP Knowledge Base Article - Public

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

Symptom

"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.

Environment

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.

Resolution

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.

Keywords

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

Product

SAP Analysis for Microsoft Office 2.8