SUM

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

Guest

I am having troubles trying to create a sum in a report. I have a report
that is grouping on different divisions. I have made some calculations in
each division on the report. I have named the cells "division Totals", it
adds different cells in the report, when I go to do a Grand total at the
bottom of the report and tell my cell to sum([Division Totals]) I get the
query box before the report runs and no information for my grand totals.
Please what am I doing wrong?
 
You can't Sum a control in a report. What you need to do is to repeat the
entire calculation again at the "bottom" of the report - in the report's
report footer.

So for example if you are using something like the following at the division
level.

Control Source: =SUM(ItemCount * UnitCost)

You need to do the exact same thing for the report total

Control Source: =SUM(ItemCount * UnitCost)
 
Sorry I wasn't clearer. I need the grand total of all the headers that have
a sum in them. They have some different calculations that aren't covered in
my query. But in each header there is a field that totals them. I have
tried to say the same thing at my grand total but all it does is calculate
one division. I need it to do all. Here is my calculation in a box called
DivisionTotals =+[Sum Of MACHCOSTS1]+[Sum Of MANCOSTS1]+[SUM OF
DRIVINGCOSTS1]+[SUPERVISIONCOSTS]+[OVERHEAD]+[1STAID]. What I have been
trying to do at the bottom is sum([DivisionTotals]). What else can I do?
Thanks

John Spencer said:
You can't Sum a control in a report. What you need to do is to repeat the
entire calculation again at the "bottom" of the report - in the report's
report footer.

So for example if you are using something like the following at the division
level.

Control Source: =SUM(ItemCount * UnitCost)

You need to do the exact same thing for the report total

Control Source: =SUM(ItemCount * UnitCost)

Akrt48 said:
I am having troubles trying to create a sum in a report. I have a report
that is grouping on different divisions. I have made some calculations in
each division on the report. I have named the cells "division Totals", it
adds different cells in the report, when I go to do a Grand total at the
bottom of the report and tell my cell to sum([Division Totals]) I get the
query box before the report runs and no information for my grand totals.
Please what am I doing wrong?
Click to expand...
Click to expand...
 
You would have to have the calculations for each of those sums in the report
footer control.

What is in Sum of MachCosts1? Is that Sum(MachCosts) or is it
Sum(MachHours*HourlyRate)?

=Sum(MachHours*HourlyRate) + Sum(EmployeeRate*HoursWorked) + ...
Akrt48 said:
Sorry I wasn't clearer. I need the grand total of all the headers that
have
a sum in them. They have some different calculations that aren't covered
in
my query. But in each header there is a field that totals them. I have
tried to say the same thing at my grand total but all it does is calculate
one division. I need it to do all. Here is my calculation in a box
called
DivisionTotals =+[Sum Of MACHCOSTS1]+[Sum Of MANCOSTS1]+[SUM OF
DRIVINGCOSTS1]+[SUPERVISIONCOSTS]+[OVERHEAD]+[1STAID]. What I have been
trying to do at the bottom is sum([DivisionTotals]). What else can I do?
Thanks

John Spencer said:
You can't Sum a control in a report. What you need to do is to repeat
the
entire calculation again at the "bottom" of the report - in the report's
report footer.

So for example if you are using something like the following at the
division
level.

Control Source: =SUM(ItemCount * UnitCost)

You need to do the exact same thing for the report total

Control Source: =SUM(ItemCount * UnitCost)

Akrt48 said:
I am having troubles trying to create a sum in a report. I have a
report
that is grouping on different divisions. I have made some calculations
in
each division on the report. I have named the cells "division Totals",
it
adds different cells in the report, when I go to do a Grand total at
the
bottom of the report and tell my cell to sum([Division Totals]) I get
the
query box before the report runs and no information for my grand
totals.
Please what am I doing wrong?
Click to expand...
Click to expand...
Click to expand...
 
The problems don't lie with the sum of machcosts1, it is sum([machcosts])
they seem to lie with the +[supervision]+[overhead] which are formulas based
You would have to have the calculations for each of those sums in the report
footer control.

What is in Sum of MachCosts1? Is that Sum(MachCosts) or is it
Sum(MachHours*HourlyRate)?

=Sum(MachHours*HourlyRate) + Sum(EmployeeRate*HoursWorked) + ...
Akrt48 said:
Sorry I wasn't clearer. I need the grand total of all the headers that
have
a sum in them. They have some different calculations that aren't covered
in
my query. But in each header there is a field that totals them. I have
tried to say the same thing at my grand total but all it does is calculate
one division. I need it to do all. Here is my calculation in a box
called
DivisionTotals =+[Sum Of MACHCOSTS1]+[Sum Of MANCOSTS1]+[SUM OF
DRIVINGCOSTS1]+[SUPERVISIONCOSTS]+[OVERHEAD]+[1STAID]. What I have been
trying to do at the bottom is sum([DivisionTotals]). What else can I do?
Thanks

John Spencer said:
You can't Sum a control in a report. What you need to do is to repeat
the
entire calculation again at the "bottom" of the report - in the report's
report footer.

So for example if you are using something like the following at the
division
level.

Control Source: =SUM(ItemCount * UnitCost)

You need to do the exact same thing for the report total

Control Source: =SUM(ItemCount * UnitCost)

I am having troubles trying to create a sum in a report. I have a
report
that is grouping on different divisions. I have made some calculations
in
each division on the report. I have named the cells "division Totals",
it
adds different cells in the report, when I go to do a Grand total at
the
bottom of the report and tell my cell to sum([Division Totals]) I get
the
query box before the report runs and no information for my grand
totals.
Please what am I doing wrong?
Click to expand...
Click to expand...
Click to expand...
 
I guess I don't understand what you are doing.

I would think you would need to replace [Supervision] with the formula you
are using to calculate supervision.

Wish I could be more helpful, but somehow I am not understanding your
problem or I am not communicating my understanding of a solution to you
properly.

Akrt48 said:
The problems don't lie with the sum of machcosts1, it is sum([machcosts])
they seem to lie with the +[supervision]+[overhead] which are formulas
based
on what is happening in those divisions. Doesn't look like I will have
much
luck getting around them. But I will keep trying.

John Spencer said:
You would have to have the calculations for each of those sums in the
report
footer control.

What is in Sum of MachCosts1? Is that Sum(MachCosts) or is it
Sum(MachHours*HourlyRate)?

=Sum(MachHours*HourlyRate) + Sum(EmployeeRate*HoursWorked) + ...
Akrt48 said:
Sorry I wasn't clearer. I need the grand total of all the headers that
have
a sum in them. They have some different calculations that aren't
covered
in
my query. But in each header there is a field that totals them. I
have
tried to say the same thing at my grand total but all it does is
calculate
one division. I need it to do all. Here is my calculation in a box
called
DivisionTotals =+[Sum Of MACHCOSTS1]+[Sum Of MANCOSTS1]+[SUM OF
DRIVINGCOSTS1]+[SUPERVISIONCOSTS]+[OVERHEAD]+[1STAID]. What I have
been
trying to do at the bottom is sum([DivisionTotals]). What else can I
do?
Thanks

:

You can't Sum a control in a report. What you need to do is to repeat
the
entire calculation again at the "bottom" of the report - in the
report's
report footer.

So for example if you are using something like the following at the
division
level.

Control Source: =SUM(ItemCount * UnitCost)

You need to do the exact same thing for the report total

Control Source: =SUM(ItemCount * UnitCost)

I am having troubles trying to create a sum in a report. I have a
report
that is grouping on different divisions. I have made some
calculations
in
each division on the report. I have named the cells "division
Totals",
it
adds different cells in the report, when I go to do a Grand total at
the
bottom of the report and tell my cell to sum([Division Totals]) I
get
the
query box before the report runs and no information for my grand
totals.
Please what am I doing wrong?
Click to expand...
Click to expand...
Click to expand...
 
Yes you did John; in a round about way if fixed it. I am really a new user
and have problems communicating my troubles. What I ended up doing was
taking the [Supervisor] calculation which is based on things that happen in
the division modifying it for inclusion in the Report footer and it now works
fine. It is not the ideal solution but until I can think of something else
it will do. Thank you for all your input.

John Spencer said:
I guess I don't understand what you are doing.

I would think you would need to replace [Supervision] with the formula you
are using to calculate supervision.

Wish I could be more helpful, but somehow I am not understanding your
problem or I am not communicating my understanding of a solution to you
properly.

Akrt48 said:
The problems don't lie with the sum of machcosts1, it is sum([machcosts])
they seem to lie with the +[supervision]+[overhead] which are formulas
based
on what is happening in those divisions. Doesn't look like I will have
much
luck getting around them. But I will keep trying.

John Spencer said:
You would have to have the calculations for each of those sums in the
report
footer control.

What is in Sum of MachCosts1? Is that Sum(MachCosts) or is it
Sum(MachHours*HourlyRate)?

=Sum(MachHours*HourlyRate) + Sum(EmployeeRate*HoursWorked) + ...
Sorry I wasn't clearer. I need the grand total of all the headers that
have
a sum in them. They have some different calculations that aren't
covered
in
my query. But in each header there is a field that totals them. I
have
tried to say the same thing at my grand total but all it does is
calculate
one division. I need it to do all. Here is my calculation in a box
called
DivisionTotals =+[Sum Of MACHCOSTS1]+[Sum Of MANCOSTS1]+[SUM OF
DRIVINGCOSTS1]+[SUPERVISIONCOSTS]+[OVERHEAD]+[1STAID]. What I have
been
trying to do at the bottom is sum([DivisionTotals]). What else can I
do?
Thanks

:

You can't Sum a control in a report. What you need to do is to repeat
the
entire calculation again at the "bottom" of the report - in the
report's
report footer.

So for example if you are using something like the following at the
division
level.

Control Source: =SUM(ItemCount * UnitCost)

You need to do the exact same thing for the report total

Control Source: =SUM(ItemCount * UnitCost)

I am having troubles trying to create a sum in a report. I have a
report
that is grouping on different divisions. I have made some
calculations
in
each division on the report. I have named the cells "division
Totals",
it
adds different cells in the report, when I go to do a Grand total at
the
bottom of the report and tell my cell to sum([Division Totals]) I
get
the
query box before the report runs and no information for my grand
totals.
Please what am I doing wrong?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top