Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a problem loading some data from excel. I try to load these data.
Distribution Cost | Month Actual | Month Budget | Month l/y | Index Budget | Index l/y | |
Denmark | kDKK | 1.289 | 1.745 | 1.507 | 74 | 86 |
Denmark | % Act | 2,35% | 2,99% | 2,66% | ||
Denmark | % T/O | 1,00% | 1,30% | 1,20% | ||
Denmark | Cost/m3 | 72 | 90 | 79 | 80 | 90 |
Denmark | Cost/m3 C. | 71 | 88 | 79 | 81 | 89 |
Denmark | Km | 159 | 155 | 158 | 103 | 101 |
But when I load the data I can not see the %-figures, but I ca find the text called % Act. Can somebody tell me why and what to do for solve it? (see report output in file)
Best regards
Bjarne
That's y i asked you to provide sample data wt you have now. B'coz if i take the data in inline i can also see the result.
Looking at your table it looks like the numbers with the % is imported as text (they are left adjusted in the column), maybe the original poster was using a numeric expression on the field.
maybe the original poster was using a numeric expression on the field
Exactly.
So
Its hard to help without looking to your script