summing

C

CAM

Hello,

I am trying to sum a column that has percentages. For example there is a
column call "Amount" containing a dollar amount and another column call
"Gross Sales" I have a calculated field call "Percentages" the formula is
{Amount/Gross Sales) what I want to do is to sum the "Percentage" field in
the footer not in the detail band. I even try to break out the formula, but
I do not get the correct results that should be "100%". How do I do that?
Any tips or website to visit will be appreciate. Thank you in advance.
 
D

Duane Hookom

From you description, I would expect the Gross Sales should be the sum of the
Amount field. If so, you should be able to use a control source like:
=Sum([Amount])/[Gross Sales]

Note: this won't work in a Page Footer section.
 

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