HELP - calculations for reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that looks like this. I just can't seem to get the total for
assets and the total for liabilities. I also need the grand total. Thanks in
advance!

ASSETS

Cash
1000
2000
3000
6000
Fixed Assets
4000
5000
9000
TOTAL:
LIABILITIES

Current Liabilities
1000
2000
3000

Other Liabilities
4000
5000
9000
TOTAL:

GRAND TOTAL:
 
Have you tried using the header/footers for the groups you require totals for?
If Assets and Liabilities are part of one field in your underlying
recordset, choose to group that field in Sorting and Grouping and choose to
have a Header and footer for it too.
Place the field in the header so that the name is shown, then place a
calculated field in the footer using the Sum function to show the total.
You'll need to use the Report footer to show the grand total. To show the
report footer if it's not already shown, select Report Header and Footer from
the View menu.
Hope that helped.
Dave
 
Thanks Dave. i have a nother question though. if you needed to get the sum,
you use
=Sum(). But what do you use when you need to subtract?
 
My reprort looks like this..

Revenue
100
200
total: 300
Cost of Sales
200
300
total: 500
Gross Margin : 200

Operating Expenses
100
200
300
total: 600

Net Income: 400

i don't know how to get the values for Gross Margin and for the net
income... i have only one field for the value.. which is SumOfNetofVat. to
get the values for total i used =Sum(SumOfNetofVAT). Please help with the
formula.. thanks in advance.

~~rai~~
 
I forgot to add that to get the value for net income, you must subtract the
total operating expenses with gross margin. i have tried working with footers
but im pretty much sure that my problem is in the formula...
 
Back
Top