Total is not dividing correctly 1

[CRilliterate]

I have data that looks like this

QTY AMOUNT AVERAGE
1.00 $2995 $2995
.025 $0 $0

1.25 $2995 $2995

Totaling fields at RFooter are SUM of Totaling fields at Groop Footer.

Like TotalQTY and SUM TotalQTY.

How do I make formula to never mind RFooter (it'll get supressed) but only to work with GFooter and have it
$2995/1.25 result?

Thanks much

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[lbass]

sum({table.amt},{table.groupfield})/sum({table.qty},{table.groupfield})

-LB

 

[CRilliterate]

I am sorry I can't seem to figure it out.
What is the groupfield in this formula?
I have only those 3 fields to manipulate
QTY AMOUNT AVERAGE

sum({table.amt},{table.groupfield})/
sum({table.qty},{table.groupfield})

So what is 'table.groupfield' ?

Tahnks

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[CRilliterate]

THANKSYOUVERYMUCH, lbass...as always you saved my day and fromula!!! Get a STAR!

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server