Calculate Sum....................

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

Guest

I created a report an in the report footer I used the sum function to total
all the records, however the one column is a % of the two columns.

For example

FTM FTA FT%
1 2 50%
2 2 100%

3 4 ???

How would I get the number I am lookin for in the report footer?

Thanks
Tony
 
If FT% is a calculated field in the report then in the footer write
=Sum([FTM])/Sum([FTA])*100

If the FT% comes from the table or the query that the report is bounded to,
so you can avarage the values, instead of sum

=Avg([FT%])
 
Ofer,

Thank for the help, the sum formula worked great.................

Tony

Ofer said:
If FT% is a calculated field in the report then in the footer write
=Sum([FTM])/Sum([FTA])*100

If the FT% comes from the table or the query that the report is bounded to,
so you can avarage the values, instead of sum

=Avg([FT%])





Tony said:
I created a report an in the report footer I used the sum function to total
all the records, however the one column is a % of the two columns.

For example

FTM FTA FT%
1 2 50%
2 2 100%

3 4 ???

How would I get the number I am lookin for in the report footer?

Thanks
Tony
Click to expand...
Click to expand...
 
Back
Top