1207028 - Data disappears on preview in Xcelsius when using array formulas in Excel

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.

• BusinessObjects Xcelsius 2008
• BusinessObjects Dashboard

data disappears using array formulas , 9726470 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To