BusinessObjects Board

Results from formulas not displayed - HELP

other Xcelsius - Crystal Dashboard Design
#1

I have a formula in Excel in Dashboard Designer I used to retrieve data from a Webi table:
IF(ISNA(VLOOKUP($B16,T$32:T$82,1,FALSE)),"",VLOOKUP($B16,T$32:T$82,1,FALSE))

This gives me the results I need with the exception that it pulls it in with spaces between some values (i.e.)

A
B
C

D
E

So I have a secondary formula in Excel which removes the spaces and the results look fine:
IF(ISNA(INDEX(D$16:D$21,MATCH(0,INDEX(COUNTIF(D$22:D22,D$16:D$21),0,0),0))),"",INDEX(D$16:D$21,MATCH(0,INDEX(COUNTIF(D$22:D22,D$16:D$21),0,0),0)))

A
B
C
D
E

until I go into preview. Then I get nothing. Can someone help to determine the issue here? All functions are supported.

fknaut :us: (BOB member since 2005-08-04)

#2

Basic troubleshooting tips:

Have you checked that the WebI block is writing data to the original area (T32:T82)?

Have you checked that your first set of formulas is writing data to the secondary area (D16:D21)?

Have you tried breaking down your formulas to see if each individual condition is returning the expected results?

Lugh (BOB member since 2009-07-16)