summing

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

 

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