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

[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

 

[Guest]

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%])

 

[Guest]

Ofer,

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

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%])

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