Currency sorting not working

  • Resolved debcsr09

    (@debcsr09)


    8 months, 2 weeks ago

    When you click on the Assessment & Measures column, the values are not sorted in order. For example, $1,000,000 is listed before $120,000 which tells me it’s not reading the values as a whole number, but instead as text. Is there a way to fix this? I really need this to work and I need the commas and $ amount to be included as well.

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

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 months, 2 weeks ago

    Hi!

    Thanks for your post and sorry for the trouble!

    The cause for this basically is that this “Assessment & Measures” column doesn’t hold the plain currency value, but actually some additional text and even HTML code.

    This switches the sorting algorithm for this column to normal “text” sorting, as the sorting algorithm can’t know that you are basically only interested in those numbers, when sorting.

    My recommendation here would be to use an approach similar to https://ww.wp.xz.cn/support/topic/sorting-column-with-currency-and-text-values/#post-15088474 That means: Add an extra (hidden) column with just the numeric values and assign that hidden column to be used as the sorting data for the visible column.

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)

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