Currency columns not sorting properly

  • Resolved cathlutz

    (@cathlutz)


    7 years, 5 months ago

    I’ve imported a .csv file into Tablepress that includes two columns with currency values. When testing the sort function, the columns do not properly sort in terms of highest to lowest dollar value and vice versa. In one, the values go down from under $1 million, then once it reaches the lowest value, starts again at the highest value (in this case over $2 million), and goes down to the lowest value over $1 million. I can’t even figure out the rhyme or reason in how the other column sorts. Thanks so much for any help you can give.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 16 through 19 (of 19 total)
1 2
  • Thread Starter cathlutz

    (@cathlutz)

    7 years, 4 months ago

    Hi Tobias,
    Thank you. I cannot figure out how to find your email so why don’t you try me: cathlutz at gmail … and let me know what you need to take a closer look.
    Thanks,
    Catherine

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 4 months ago

    Hi,

    sure, will do!

    Regards,
    Tobias

    solari1

    (@solari1)

    7 years, 3 months ago

    I’m attempting to display $M in TablePress. Where the sort produces MSD 1st. Is there some custom code I can use to adjust the sort?

    Plus, in the custom code you gave as an example,
    “columnDefs”: [ { “type”: “fomatted-num”, “targets”: [ 3, 6 ] } ] “3” & “6” are columns C and F. Yes?

    Also note https://www.datatables.net/> appears to be down.

    Thx,
    JQ

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 3 months ago

    Hi,

    I’m not sure that I understand what you want to show. Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

    And no, 3 and 6 would refer to columns D and G (counting starts with 0). Also, https://www.datatables.net/ is working fine for me.

    Regards,
    Tobias

Viewing 4 replies - 16 through 19 (of 19 total)
1 2

The topic ‘Currency columns not sorting properly’ is closed to new replies.