G
Guest
I am having difficulties with a calculation in my report.
What I currently have is a range report that calculates number of covers in
a restaurant on a month to month basis, this in turn makes some calculations
with cost and revenue. When I due a date range for any given month, the
calculations work great. However, when I want to do a range for a two month
period (i.e. 06/01/06-07/31/06). The months remain separated so we can view
the comparison, however the one field that does the total covers calculation
now shows the total for both months together, which obviously scews the cost
per person analysis for both months.
PLEASE HELP! I am sure there is something wrong with the control source
expression I currently have which is as follows:
=(Sum([TotalPaid])+Sum([TotalComped])+Sum([TotalAddGsts])+Sum([TotalKids]))
But when I try to alter it to this:
=[TotalPaid]+[TotalComped]+[TotalAddGsts]+[TotalKids]
this expression just places all the numbers in a long string (eg. June 06
should read 4325 covers, instead it strings 3539404250132. Which is for 3539
Paid, 404 Comped, 250 Additional Gsts, and 132 Kids.)
Any suggestions? Sorry for the long questions, I just wanted to give you the
best idea of what I'm doing.
Thanks
What I currently have is a range report that calculates number of covers in
a restaurant on a month to month basis, this in turn makes some calculations
with cost and revenue. When I due a date range for any given month, the
calculations work great. However, when I want to do a range for a two month
period (i.e. 06/01/06-07/31/06). The months remain separated so we can view
the comparison, however the one field that does the total covers calculation
now shows the total for both months together, which obviously scews the cost
per person analysis for both months.
PLEASE HELP! I am sure there is something wrong with the control source
expression I currently have which is as follows:
=(Sum([TotalPaid])+Sum([TotalComped])+Sum([TotalAddGsts])+Sum([TotalKids]))
But when I try to alter it to this:
=[TotalPaid]+[TotalComped]+[TotalAddGsts]+[TotalKids]
this expression just places all the numbers in a long string (eg. June 06
should read 4325 covers, instead it strings 3539404250132. Which is for 3539
Paid, 404 Comped, 250 Additional Gsts, and 132 Kids.)
Any suggestions? Sorry for the long questions, I just wanted to give you the
best idea of what I'm doing.
Thanks