Sorting a column of numbers incorrectly

  • Resolved evanmedeiros

    (@evanmedeiros)


    3 years, 5 months ago

    url: https://www.thetraderisk.com/sandbox/
    password is: tablepress

    Hello Tobias,

    It seems like we’re running into the issue where the sort algorithm is sorting baed on text rather than numbers for a handful of our columns within the table:

    Market Cap
    Volatility
    Price
    Distance 52W High
    20 day return

    Maybe the decimal point and ‘%’ is throwing things off? Is there a way we can enforce numbers (or percentages) on those columns?

    Thank you!
    Evan

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Most likely, it’s not the percentages themselves, but that one row with the #VALUE! text in the cell.

    Regards,
    Tobias

    Thread Starter evanmedeiros

    (@evanmedeiros)

    Ah of course! Just fixed that row and everything is sorting correctly again.

    Thanks for fast support, just donated a few cups of coffee.

    Evan

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias
    ?
    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Sorting a column of numbers incorrectly’ is closed to new replies.