Sorting numbers past 1 million
-
I’m having trouble sorting columns once the values in a column contain figures greater than 1,000,000. There are no decimals used in this column; in any case I would use a “dot” as is the North American standard (and I believe the default for Tablepress).
In any case, as soon as I add the second comma, those values are sorted after rows containing hundred-thousand items.
In other words, sorting works perfectly for values such as 100,000 or 952,000 but if I add 1,083,000, that is interpreted as a smaller, not a larger number.
I have investigated the two possibly relevant extension plugins and I more or less understand the parameters of the issue, but I can’t get it to work. I assume in “Change DataTables strings” that “thousands” should equally apply to “thousand thousand, i.e., the comma denoting a million, but that seems not to be the case.
- The topic ‘Sorting numbers past 1 million’ is closed to new replies.