SAP Knowledge Base Article - Public

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


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.


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.



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


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


 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


SAP Analysis for Microsoft Office 2.8