SUM of Two Columns (HELP) CRYSTAL REPORT in VB.NET
My table name is "accounting"
it has two columns named "Debit" and "Credit"
Is it possible to have the sum of these two columns?
example
Code:
INPUT:
Debit Credit
200 + -100
300 + -300
500 + -400
-------- ----------
1000 -800
I want it to appear like this in my Crystal Report:
Code:
Debit Credit TOTAL
200 -100 100
300 -300 0
500 -400 100
-------- ---------- ---------
1000 -800 200
I dont know what FORMULA I should use in Crystal Report
Re: SUM of Two Columns (HELP) CRYSTAL REPORT in VB.NET
sum({table.field}) should give you the sum of each data column. for the values in the total column you should be able to use a formula like {table.debit}+{table.credit}