I have a report summarizing data on neighborhoods and on zip codes.

There are two totals: revenue and people (Both summary fields)

The two totals are fine in the summary reports, but I cannot get an average on the two totals

What I would like is total rev/total people = Avg. Price

I would like this to appear on the report by neighborhood or zip.

I can get the total rev/total people to appear on each line with the same value on each, the aggregate total, but not breaking on each sorted field (neighborhood or zip).

So far I have tried getSummaries on both totals and also running totals that restart on zip or neighborhood depending on which report I am running, but I cannot get the average to show up.

I would appreciate any help this is surprisingly annoying because it seems like something that should be easy to do.

Thanks

Create a calculation field that is = revenue / people (check that people is non-zero). Then make a summary field that averages this calculation.

What I would like is total rev/total people = Avg. Price

I would like this to appear on the report by neighborhood or zip.

Try =

GetSummary ( sTotalRevenue ; Neighborhood ) / GetSummary ( sTotalPeople ; Neighborhood ) 

Records must be sorted by Neighborhood for this to work.