Sorting Problem
Hi
There was a problem sorting into a table
Format for display in the table text + Number
the same problem in dynamic selection formula for display 'Machine Room'.'Slot Machine2' order by 'index'
Has anyone encountered this? Please suggest solutions
3 replies
-
That is not a bug. When you mix text and numbers it is treated as text, so when you sort text you do it one letter/number at a time. That means there is no such thing as 10's or 100's. You start sorting with the first letter/number which is A. Then you sort by the second letter/number which is 1, so all records with A1 in it are pulled to the top. Like it would be if you had AB, ABC, ABD, ABE, AC. All AB would sort before AC.
The work around would be to put a zero in front of single digit numbers (01, 02, 03, etc). or if you are going into the hundreds then two zeros. Then it will sort "numerically".
Content aside
- 2 wk agoLast active
- 3Replies
- 17Views
-
2
Following