in SQL you can do this:
select sum(chequeamount) as ROInc_amt, 0 as Inc_amt
how can you do this in a webi report though when I try it doesnt parse what is the syntax to use?
_________________
BO Edge XI 3.0
App server: MS Win2003 Server Standard SP2
DB server: MS Win2003 Server Standard SP2
DB on DB server: SQL 2005