Hi!Got a view where one of the columns I´m using is sorted : "ascending " and “standard” (numbers)
Everything worked fine untill there was over 100 documents - then the sortorder suddenly showed: 8, 9, 100, 101…, 11
How do I do to get it right (that´s to say that 100 comes after 99…)
Thanks
/Leif
Subject: Sorting in views
If this is set to a number already, it should work fine, if this is the first sorted column. If you think it might be text add a @ToNumber(fieldname) around it. If this is still not working, you must have another column that is sorted before it. Check the sorting on the other columns.
Subject: Sorting in views
The column is sorting as text, it would seem, which makes the sort in alphabetical rather than numeric order. All it takes is one value to be text and the whole thing is treated as text. If the field is actually storing text, then modify your form and run an agent to convert the existing values. If the field is storing numbers, then you’ll need to find the document(s) that has (have) it wrong.