BusinessObjects Board

BIWS not picking up the format

I’ve set up a BIWS in my dashboard, but it’s not picking up the format from my webi block.

In my webi block it’s showing me: 5,7%
(set up with FormatNumber #,##0.0[%]%, the actual decimal number behind this is 0,057)

But my xcelsius dashboard is showing me: 57000e-6

Even the Xcelsius component which is binded to the BIWS cell in excel is set-up with the format: Percent ; 1 decimal.

It’s doing this with every number coming from BIWS.

ps
I’ve also set up some numbers to display as text (ratio’s like: 75 / 25 ) and they are displayed correct, should I transform all numbers to text? (that’s strange?)


Tiny :netherlands: (BOB member since 2004-11-10)

Is the format set on the Excel cell? Sometimes, against all logic, that makes a big difference.


Lugh (BOB member since 2009-07-16)