How to sort ascending a column that has positive and negative values so the result would go from negative to positive?
Here is the column definition:
Value: $replace(%REPLAYGAIN_TRACK_GAIN%, dB,)
Sort by: $replace(%REPLAYGAIN_TRACK_GAIN%, dB,)
Notes: I remove the "dB" so I do a numerical sort. I tried with and without = same result.
It's a bit ackward:
a. the sort does not see the negative sign
b. it sort the integer portion ascending from 0 to 9, then sorts the fractional portion descending
My objective: sort the field so it goes from biggest negative, to zero, then to the biggest positive (like in a spreadsheet)
Thank you for any assistance.