Report Grand Total


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
 
Ad

Advertisements

M

Marshall Barton

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])

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

D

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])

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

Marshall Barton

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])

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

Advertisements

D

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top