Calculated Report

  • Thread starter Thread starter dar
  • Start date Start date
D

dar

I'm attempting to create a report that has 4 calculated
columns. Each column is totaled. What I would like the
ending result to be is column 1 and column 2 are added
together and the subtotal is used for column 3 and column
4 totals to be subtracted from the total of 1+2. Can this
be done?
Example: col(1)2000 + col (2) 175 = 2175 -col(3)475 - col
(4) 254 grandtotal (1446).

Thanks,
 
Dar,
I'd set up for calculated fields..
=(Sum(Col1) + Sum(Col2) - (Sum(Col3)) + Sum(Col4))
 
Back
Top