summarizing a summary field

[15a0]

I am tracking the number of items per month

I have a year and month field in the table.

I have a report that has leading and trailing subsummary for year and month.

on the leading subsummary by month, I can correctly total the items using "countofmonth" summary field.

on the trailing subsummary by year, I can also total the items for the year by using a calculation getsummary(countofmonth, year)

What I really want is a to display the average number of items per month. At a minimum, just the simple grand "average per month", but this on a yearly basis would be cool too.

What I cannot do is perform this calcuation:

If the yearly total for an item is 60, I cannot come up with a way to divide it by the number months (which would of course be 12)

any suggestions would be appreciated

Edited November 5, 2008 by Guest
Added Type

[15a0]

After looking at this, I think I made it too hard to understand.

I reposted under this heading:

[color:black]

average of a "count" field

Sorry for the mixup