Calculation Expression Help

[knowshowrosegrows]

I have a group footer where I have successfully put in some controls that
give me the sums of a number of fields. Now I want a text box control that
will give me a percentage calculation for two of those sums. I can't figure
out how to write the expression. This is my latest failed attempt -
=(Sum([Beds Avail])/(Sum([CAP]))).

The first to supply the right answer gets to have my virtual statue of the
Laughing Buddha sit at your desk over the weekend!

 

[KARL DEWEY]

Are [Beds Avail] and [CAP] fields in your table/query or calculated in the
details section? If the latter then you need to use their calculation
instead of their names.

Also if you count the opening parenthesis verus the closing you have a
mismatch.

 

[knowshowrosegrows]

They are calculated controls in the group footer. They come out fine and
transfer fine to Excel.

In searching the website I have found the expression that works in the
percentage control on the report. It is =Sum([Beds Avail])/Sum([CAP]). Now
the trouble I am having is that when I publish this report to Excel, it
publishes all the other calculations but simply leaves this blank.

The Laughing Buddha awaits.
--
Thanks

Are [Beds Avail] and [CAP] fields in your table/query or calculated in the
details section? If the latter then you need to use their calculation
instead of their names.

Also if you count the opening parenthesis verus the closing you have a
mismatch.
--
KARL DEWEY
Build a little - Test a little

I have a group footer where I have successfully put in some controls that
give me the sums of a number of fields. Now I want a text box control that
will give me a percentage calculation for two of those sums. I can't figure
out how to write the expression. This is my latest failed attempt -
=(Sum([Beds Avail])/(Sum([CAP]))).

The first to supply the right answer gets to have my virtual statue of the
Laughing Buddha sit at your desk over the weekend!

 

[KARL DEWEY]

Did you try using use their calculation instead of their names like I
siggested?

=Sum(Formula for Beds Avail)/Sum(Formula for CAP)
--
KARL DEWEY
Build a little - Test a little

They are calculated controls in the group footer. They come out fine and
transfer fine to Excel.

In searching the website I have found the expression that works in the
percentage control on the report. It is =Sum([Beds Avail])/Sum([CAP]). Now
the trouble I am having is that when I publish this report to Excel, it
publishes all the other calculations but simply leaves this blank.

The Laughing Buddha awaits.
--
Thanks

Are [Beds Avail] and [CAP] fields in your table/query or calculated in the
details section? If the latter then you need to use their calculation
instead of their names.

Also if you count the opening parenthesis verus the closing you have a
mismatch.
--
KARL DEWEY
Build a little - Test a little

I have a group footer where I have successfully put in some controls that
give me the sums of a number of fields. Now I want a text box control that
will give me a percentage calculation for two of those sums. I can't figure
out how to write the expression. This is my latest failed attempt -
=(Sum([Beds Avail])/(Sum([CAP]))).

The first to supply the right answer gets to have my virtual statue of the
Laughing Buddha sit at your desk over the weekend!