Sorting number fields in descending order. Null values appear first? That's weird

[Jim Hathaway]

I have a number field that I want to user order by desc in a JQL query.

Most records are populated with a number but some are empty. the search results appear to sort the empty/null values first, then high numbers to low numbers.

This is counterintuitive. Empty or Null values should be in the same place as Zero or below the lowest number, not at the top.

Can I fix this with some clever query or is it not working the way I expect it to and Atlassian need to fix it.?

[John Funk]

Hi Jim - Welcome to the Atlassian Community!

Any reason to not default the field to 0?

Do you need to see the work items without a value? You could exclude those in the query. 

Not sure why it is showing the null values first. Does DESC put them at the end?