After some calculations I store a number, which can be negative or positive, in a characteristic. NUMC shows me a weird number when <0 and CHAR shows numbers like 1 -, 2, 3 -. These are correct, only the sign is located after the number.
I want to group the outcome in the columns of a report, but the result I get now has a sorting order of: 0, 1, 1 -, 2, 2 -, 3, 3 - etc.
I want it to be in a sorting order of - 2 , - 1, 0, 1, 2 etc. So the sign is in front.
I have been reading a lot for the last day, but never saw a solution. For instance I could not find a conversion routine, which does it.
Does somebody know how to handle negative numbers, so that the group sorting order is shown correct in the report?