November 5, 200817 yr 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, 200817 yr by Guest Added Type
November 5, 200817 yr Author 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
Create an account or sign in to comment