Symptom
You have a formula containing variables referencing a cell range in Excel.
If you create a model using an Excel data source which contains formulas such as the following:
=IF (COUNTRY<>"", Revenue*5)
where COUNTRY and Revenue are variables with data range values.
While previewing the model in .xlf, the chart/graph content will disappear.
If you display the data in a table, then "NaN" (Not a Number) will be displayed.
Read more...
Environment
- BusinessObjects Xcelsius 2008
- BusinessObjects Dashboard
Product
Keywords
data disappears using array formulas , 9726470 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.