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
- Open a query in BEx Analyzer where the results row contains a sum of mixed currenciels.
- Observe * in the cell and a numerical values in the formula bar.
- Open the same query in Analysis for Office.
- Observe * in the cell and * in the formula bar.
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