InList Function is not working for multiple values in Webi

[Former Member]

Hi,

I have a scenario where InList function working fine on OLAP universe (webi report) for multiple values and giving #UNAVAILABLE error on BICS (webi)report for the following formulas -

• Working Fine - OLAP Universe (Webi Report)

  =[Actual LTD CY] Where( [L02 G/L Account Key] InList ("BIUS51";"BIUS52";"BIUS60";"BIUS65";"BIUS66");[L02 G/L Account Key])

  When we used same formula in BICS report getting #UNAVAILABLE error - Single value used INLIST function give the proper results.

  Formula works fine for Single value -

  =[Actual LTD CY]Where( [BIBW - Financial Statement Version for USG].[Level 03]InList ("External Revenue");[BIBW - Financial Statement Version for USG].[Level 03])

  Error - #UNAVAILABLE for multiple InList values

  =[Actual LTD CY] Where( [BIBW - Financial Statement Version for USG].[Level 03]InList ("External Revenue";"Internal Revenue";"Operating Costs");[BIBW - Financial Statement Version for USG].[Level 03])

  Could you please advise to work InList function for multiple values in BICS (webi) report or if there any work around...

  Thx

• Naveed