Report Grand Total

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

D

Hi :

Can you please tell me how can I add thesse two on a grand total of a
report; I get cannot have sum on a agrgate function...

=Sum(Sum([Gross Sales CAD])-[Sep Budget CAD])

Thank you,

Dan
 
D said:
Can you please tell me how can I add thesse two on a grand total of a
report; I get cannot have sum on a agrgate function...

=Sum(Sum([Gross Sales CAD])-[Sep Budget CAD])
Click to expand...


Sorry, but that doesn't make sense. Please explain what
Gross sales and Sept budget are and why one Sum is not
sufficient.
 
Hi Marshall:

This is in Subtotal By Brand: Sum([Gross Sales CAD])-[Sep Budget CAD]); and
I wanted the Grand Total as a sum of the Subtotal?

Does it make sense?

Thank you,

Dan

Marshall Barton said:
D said:
Can you please tell me how can I add thesse two on a grand total of a
report; I get cannot have sum on a agrgate function...

=Sum(Sum([Gross Sales CAD])-[Sep Budget CAD])
Click to expand...


Sorry, but that doesn't make sense. Please explain what
Gross sales and Sept budget are and why one Sum is not
sufficient.
Click to expand...
 
Yes, that makes sense, but it won't work for two reasons.
The first reason is the one you already ran into and the
second is that sum only operates on record source fields
(not controls in a form/report).

Fortunately, there's a minor bit of math that can be used to
simplify the problem. I.e. (A+B) + (C+D) equals A+B+C+D

So, all you have to do is Copy/Paste the expression you used
in the group footer text box into the report footer text
box.
--
Marsh
MVP [MS Access]

This is in Subtotal By Brand: Sum([Gross Sales CAD])-[Sep Budget CAD]); and
I wanted the Grand Total as a sum of the Subtotal?

Does it make sense?


Marshall Barton said:
D said:
Can you please tell me how can I add thesse two on a grand total of a
report; I get cannot have sum on a agrgate function...

=Sum(Sum([Gross Sales CAD])-[Sep Budget CAD])
Click to expand...


Sorry, but that doesn't make sense. Please explain what
Gross sales and Sept budget are and why one Sum is not
sufficient.
Click to expand...
Click to expand...
 
Thank you Marshall!

I have tried; it does not give the right result; what I dit for now, is (not
very good): Gross Sales - Budget (hardcoded, it is fixed)....

Thanks gain,

Dan

Marshall Barton said:
Yes, that makes sense, but it won't work for two reasons.
The first reason is the one you already ran into and the
second is that sum only operates on record source fields
(not controls in a form/report).

Fortunately, there's a minor bit of math that can be used to
simplify the problem. I.e. (A+B) + (C+D) equals A+B+C+D

So, all you have to do is Copy/Paste the expression you used
in the group footer text box into the report footer text
box.
--
Marsh
MVP [MS Access]

This is in Subtotal By Brand: Sum([Gross Sales CAD])-[Sep Budget CAD]); and
I wanted the Grand Total as a sum of the Subtotal?

Does it make sense?


Marshall Barton said:
D wrote:
Can you please tell me how can I add thesse two on a grand total of a
report; I get cannot have sum on a agrgate function...

=Sum(Sum([Gross Sales CAD])-[Sep Budget CAD])


Sorry, but that doesn't make sense. Please explain what
Gross sales and Sept budget are and why one Sum is not
sufficient.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top