Skip to Content
0
Former Member
Jun 03, 2011 at 10:39 AM

How to Subtract two columns and show the result in third column

1320 Views

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