Hi All,

I'm writing a report that displays a statement for banking transactions. the report has 3 separate columns, namely for debit, credit, and a running total.  the values for debit and credit are derived from a single field (TRANAMT) and is determined to be a debit when it is < 0 and credit when > 0.


i have written a formula in column 1 (debit) as such : IIF({TRNAMT}<0,{TRNAMT},0)
and in column 2 (credit) as such : IIF({TRNAMT}>0,{TRNAMT},0) so that when TRANAMT < 0 then TRANAMT would be displayed in column 1 (debit), otherwise, column 2 (credit).

the problem is that when the transaction is a credit then the credit column will have the TRANAMT value but the debit column will have a value of 0.  how do i do it so that it will only display for the credit column and *not display anything* for the debit column?

can somebode help me please?

Thanks!

oh yeah - one more option for you. Use two detail sections. Each one displays the amount in a different column and use your IF THEN statement to determine which one to show and hide the other.

You need to create a formula with two global variables that track the total number of debits and credits. Within that formula check the whether it is a debit or a credit and increase the appropriate global variable. Then display these two totals under the appropriate column.