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

[David Pilcher]

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.

 

[Marshall Barton]

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.

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.