Calculating off of Sum's in a footer of a report

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

Guest

I have a NET field & a GROSS field - both are numbers. I run a report where I
group that data by a third field and query the data by date. This is my
problem. I need to in the footer of the groups (via third field in the
report) to calculate off the sums of my query.
GROUP 1
NET GROSS
5000 7000
3000 4000
SUMS 8000 11000 - - > IN THE FOOTER (SUM GROSS - SUM NET)/SUM
NET.

Can't get that additional field to calculate off of sums in the footer.
Thanks for your help in advance.
 
I have a NET field & a GROSS field - both are numbers. I run a report where I
group that data by a third field and query the data by date. This is my
problem. I need to in the footer of the groups (via third field in the
report) to calculate off the sums of my query.
GROUP 1
NET GROSS
5000 7000
3000 4000
SUMS 8000 11000 - - > IN THE FOOTER (SUM GROSS - SUM NET)/SUM
NET.

Can't get that additional field to calculate off of sums in the footer.
Click to expand...

What did you try? What happened?

As long as Gross and Net are **fields** in the report's
record source table/query, I think you should get the
correct value from this expression:
=(Sum(Gross) - Sum(Net)) / Sum(Net)

But, your description is more than a little fuzzy so you may
have some unexplained complications that are getting in the
way.
 
Back
Top