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 (BOB member since 2004-11-10)