SAP Knowledge Base Article - Public

3457524 - Different currencies summed in BEx Analyzer formula bar, but not in Analysis for Office

Symptom

When there is a sum of mixed currencies in a query, BEx Analyzer is showing asterisk (*) in the cell and a numerical value in the formula bar. Analysis Office is showing * in the cell and * in the formula bar.

Environment

SAP BEx analyzer
SAP Analysis for Office

Reproducing the Issue

  1. Open a query in BEx Analyzer where the results row contains a sum of mixed currenciels.
  2. Observe * in the cell and a numerical values in the formula bar.
  3. Open the same query in Analysis for Office.
  4. Observe * in the cell and * in the formula bar.


Currencies_sum_bex_ao.png

Cause

Excel is summing the numbers for BEx Analyzer in the formula bar not the backend.

Resolution

Analysis Office is working correctly, because summing different currency values does not make sense. The values in BEx Analyzer formula bar should be ignored.

See Also

Article about summing currencies in the SAP Help Portal

Keywords

 bex analyzer, analysis office, currency, currencies, mixed, sum, summing, amount, result, results, asterisk , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WB-7X , 7.x Analyzer Frontend , Problem

Product

SAP Analysis for Microsoft Office 2.8