Hi,
I want to segregate the amounts shown in a report field into two new different columns/fields.
i want positive amount value should go to column1
and negative amount value should go to column2.

How can i sort the amounts?

Thanks.

If I understand you right, you would like to separate one value into two columns. That could be achieved with a print expression:

column 1: value = field; print expression: $$ >= 0
coulmn 2: value = field; print expression: $$ < 0

Günther

Thanks gunther,
It worked...









If I understand you right, you would like to separate one value into two columns. That could be achieved with a print expression:

column 1: value = field; print expression: $$ >= 0
coulmn 2: value = field; print expression: $$ < 0

Günther