This is the data....
Date DocNum Amount Debit Credit
2011-04-21 00:00:00.000 9150051 497265.000000 422605.000000 497265.000000
2011-05-26 00:00:00.000 9150188 497265.000000 74660. 000000 497265.000000
2011-04-07 00:00:00.000 9290020 497265.000000 0.000000 497265.000000
I want to display the total Sum (Debit) - 497265(Amount) in Credit column
kindly give me the solution for above problem.
Regards
Rahul