>I would like for the positive numbers to list on top so as to go from higher to lower. Is there a way around that/this?
>
Add an extra field, ..., abs(fieldxy) as absval, ... order by absval descending

You don't need to show that extra field anywhere, just use it for ordering.