group summary

[bharathi228]

hi,
iam having grouping in my report.here iam having columns like hours,daily_total,average

i want to summarize average field.formula is

sum(average)=sum(daily_total)/sum(hours)

i want this one group wise. in my report iam using formula filed.but its not giving the result group wise.

it gives the result of total groups.help me

 

[IanWaterman]

In you group footer add a formula based on group summaries

sum(average, groupfield)=sum(daily_total, groupfield)/sum(hours, groupfield)

Ian