Hi all,
I have a slight sorting issue with the WEBi (XI). I have a report written in DESKI, which is sectioned by an Employee number. This is then sorted by Employee number (Asc), so that I get a list which goes like this:
1, 2, 3...100, 101,102...1000,1001...
I then converted this report to WEBi, and whereas the conversion went well overall, the sorting seems to be broken, as the order in WEBi is now:
100000, 100001, 10002...101, 102, 103, 21, 22, 23, and so on, meaning as far as I can understand it that the WEBi is not reading this as an actual number, but rather as a string of digits.
I've of course made sure this number is in Number format, but this seems to have no affect.
And ideas please?