Sum a calculation on a report

[wrightie]

Hi,

I'm hoping this is possible as it's going to save me a lot of time.

On my report which is based on a query. I'm using these two fields for a calclation.
Name: PremiumA
ControlSource: PremiumA
Name: Rate
Controlsource: Rate

Now for the calculation of field.
Name: PremiumABal
ControlSource: =[PremiumA]/[Rate]

Now the above works perfectly but what I'd like to do is have a total in the group footer for the PremiumABal field.
Is this possible as it's a calculation field ?

I hope this makes sense
Cheers
wrightie

 

[DCrake]

Have you actually tried it? Why not give it a go, then if it does not work then ask why?

 

[wrightie]

Hi,

Yeh of course I've tried it I'd much rather figure it out on my own than ask for help!

What I've tried doing is creating a total of PremiumA and then dividing that by the rate. But obviously the rate field differs so it doesn't total properly and I've tried =[PremiumABal] but it only displays the last amount of PremiumA tried changing it to a running sum and still just shows the last amount.

wrightie