/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
Formula-based indexes for your VLOOKUP array are not changing at run time.
Cause
In order to maintain the speed and efficiency of the VLOOKUP function, Crystal Xcelsius does not recalculate formulas in the index column of a VLOOKUP array.
Resolution
If you have a VLOOKUP function that contains a formula in the index column, the index column cell will always contain the initial value of the formula.
Keywords
Xcelsius runtime , 66577 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Dashboards 3.0 ; SAP BusinessObjects Dashboards 3.5 ; SAP BusinessObjects Dashboards 4.5 ; SAP BusinessObjects Dashboards software 4.0
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)