Order of Categories

Mike_L

I wanted to have my categories in a specific order. I numbered them 10, 20, 30….

When I got to 100, it was stored as coming before 20.

ie: 10, 100, 20, 30…

While my workaround was to stop the numbering at 99 and skip to 900 It worked for me as I have less than 200 categories. I was wondering if there is some rational as to why they have 100 coming before 20 in the sort routine?

UKR

I was wondering if there is some rational as to why they have 100 coming before 20 in the sort routine?

The Category Name field is a text field and not a decimal numeric field like a right-aligned amount field.
Sorted strictly by the alphabetic character sort sequence, 100 does indeed come after 10 because it begins with a 1

If you want to have your categories named with a numeric prefix, there must be enough digits including leading zeros to mimic a right-alined numeric field of sufficient length to contain the largest expected numeric value.
For example, 0001, 0002, 0003, 0010, 0020, … 0100, 0101, … 0200, 0300, … 0900, 1000, … 9999
or 00001, 00002, 00003, 00010, 00020, … 00100, 00101, … 00200, 00300, … 00900, 01000, … 09999, 10000 … 99999

Mike_L

Makes sense.

Thanks