distinct between positive & negative numbers of a single column 1

[chochoo]

hi
i want to know how to distinct between postive and negative number of a summary based column in reports at run time.
i want to put positive numbers in seperate column and negative in seperate.
thanx in advance

 

[sem]

You may use decode() in your base query:

select
...
decode(sign(col),1,col,null) pos,
decode(sign(col),-1,col,null) neg,
...

You mayalso print them in the same column but with differnt colors/styles by using format triggers.

Regards, Dima

 

[chochoo]

thanx sem! Now i've solved my problem