I have a price column for my products and trying to use the in-app sort feature to allow a user to sort the list of products by price.
Unfortunatly the feature seems to be sorting the price in a weird way. For example instead of 1.99, 2.99, 3.99, 12.99, 20.00 and 34.99, I’m getting 1.99, 12.99, 2.99, 20.00, 3.99, 34.99. So it’s only looking at the first digit rather than theentire figure. I’ve tried changing the column from text to number and vice versa and I get the same result.
Any suggestions on what I can do to fix it?