Report Grand Total

[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

 

[Marshall Barton]

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]

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

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.

 

[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?

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]

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

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?

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.