Good morning,

I currently have a formula that is working out the Daily Growth based on an Average of each days disk size (grouped by day): http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=21098.


What I would now like to do is to create (in the Report Footer if possible) an Average Daily Growth. For example I currently have the following:


Date, Computer, Disk, Disk (MB), Avg Used (MB), Daily Difference

02/10, Comput1, D1, 100, 60, 0
03/10, Comput1, D1, 100, 68, 8
04/10, Comput1, D1, 100, 65, -3
05/10, Comput1, D1, 100, 80, 15

So I would like to average the Daily Difference column to give me this in the footer:

Average Daily Growth: 5


The main problem being that I obviously can't summarise a summary (Daily Difference).

Thanks in advance!!

Thank you for your reply. I have been able to achieve what was required by using an Array Variable.