I'm using ORDER BY on a custom field which contains a number to a few decimal places. For some reason it considered 27.xxx to be lower than 3. I think I know why (it counts 27 as 2.7), but why does it do that? Is there a workaround for it?
I'm using this custom field to do prioritisation so 27 being under 3 is a big deal for me.
Here is the JQL:
project = x AND "Calculated Priority" is not EMPTY ORDER BY "Calculated Priority" DESC
