I am experiencing an issue when sorting subtables by increasing/decreasing price, and the number of decimal places are not the same across all entries in the sorted field. Please have a look at the examples posted in the two photos below. The green background line indicates the entry with the lowest price. In the first photo, Ragic sorts the lowest price to the line 2 spot instead of line 1. The second lowest price entry is sorted as the lowest price because that price field only goes to one decimal place and the others go to three. But if I change that price to $16.401 (see in the second photo), then Ragic sorts the subtable properly. The same thing happens if I sort from largest to lowest price… the lowest price entry moves to second from the end when it should be last.
Am I doing something wrong? Any fix for this?
Sorts improperly:
Sorts properly:
