Skip to Content
0
Former Member
Dec 29, 2008 at 09:47 PM

Problem with a string

22 Views

Hi,

I have a report (made with crystal reports) in wich I have embedded a xcelsius dashboard. I am passing string values to that dashboard using a crosstab (I am forced to do this that way due to programming and database limitations). Examples of those string would be :

  • 15426, 1000, 34567, ...

In my xcelsius model, i then extract each of the values to separate columns and use them to populate a table. I use FIND and MID functions to do so. I then get the following

CELL A1 : 15426

CELL A2 : 1000

CELL A3 : 34567

CELL A4 : =A1A2A3+A4

When i hit preview, i get all the values in my table exept the cell A4 value... its like xcelsius cant make the calculations passed a certain level .....

I tried to copy/paste the string directly in my xcelsius model with same results...

Thanks for your help guys

PS: Sorry for my real bad english... I tried my best to explain my problem...