Hi Dimitri,
Not work for?!?
The problem can cause decimal part...
FIELD1 + STR(100000000 - UNIT_PRICE*100,10) + FIELD2
MartinaJ
>Hi,
>
>I need to sort report on 3 fields:
>
>FIELD1 + UNIT_PRICE + FIELD2
>
>FIELD1 and FIELD2 are CHAR types. UNIT_PRICE is DECIMAL
>
>The key is that the sort on UNIT_PRICE would be descending. That is, the higher number appearing at the top. I tried the following:
>
>
>FIELD1 + STR(1000000 - UNIT_PRICE,10,2) + FIELD2
>
>
>But it does not seem to work. Or does not work all the time. What am I doing wrong?