Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Tuesday, April 7, 2015 7:54:15 AM(UTC)
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 109

I made a comparison with two groups of items.

Group 1: Item number between 100-200
Group 2: Item number between 300-400

With this grouping I expected to see only item numbers between 100 and 200, not item 100, 1001, 1002, 1003, 102, 1020" and so on.

How can this be solved? If I filter between 100 and 200 in Excel only numbers in this range shows.
Niels Thomsen  
#2 Posted : Wednesday, April 8, 2015 1:33:45 PM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 110


I would suspect the your Item number is in fact a text column in the ERP database, even though you may only use that particular column for numbers it is probably defined as text "behind the scene".

When a column is formatted as text the sort order is like this:


The column is left-justified and sorted according to evaluation of first character - then next character etc.

When you export it to Excel - well I think Excel takes an educated guess based on the content of that column and considers it to be a number (which is in a sense wrong...)

If you want to consider this column to be a number when working with it in TARGIT I think a redesign of your Item dimension would be needed.
Hope it makes sense.

Best Regards
Niels Thomsen


Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.