#dominoforever | Product Ideas Portal

 

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Sorting columns with number

At present, if numbers are in a format including thousand separator, any sorting is done alphabetically and not by value. This really is a real handicap when working in applications with lots of numbers. Sorting a numericl column ought to be numeric....ought it not ?!?

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Feb 5 2020
  • Likely to implement
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    05 Feb 19:14

    This happens if the field you entered the number in is a text field.

    If that is the case, add a computed column with the formula @texttonumber(yourfieldhere)

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    05 Feb 11:55

    Can't say I've ever experienced this but there may be an edge case?

    I just double checked to make sure but if the number is a number then it will be sorted numerically regardless of the column formatting.

    Are you sure your not trying to sort a text item and expecting it to be sorted numerically?