SAP Knowledge Base Article - Public

3253954 - Incorrect scaling number format displayed in Analysis for Office

Symptom

Analysis for Office displays incorrect scaling number format. 
Same query executed in Web report or in RSRT transaction showing the correct format.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Open Analysis for Office;
  2. Run any query, which contains number or currency values;
  3. Result set displaying wrong format.

Cause

MS Excel overwrites the digit grouping from region settings.

Resolution

  1. Open Control Panel;
  2. Open Region settings;
  3. Open "Additional settings..."
  4. For number format, open "Number" tab and adjust the "Digit grouping" settings to the correct format. For currency format, please open "Currency" tab and and adjust the "Digit grouping" settings to the correct format.

Keywords

incorrect currency format, scaling number format, Analysis for Office, AO , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BPC , Please use component BI-RA-AO-XLA , Problem

Product

SAP Analysis for Microsoft Office all versions

Attachments

Pasted image.png