There are two basic solutions to this problem.

One is to create a manual running total of the formula. Declare a global variable. With each record, add the current average to this variable. In the footer, simply divide the variable (now the sum of all your averages) by a count of the records (using the Count function). This will give you an average of the averages.

A second is to re-create the essence of the earlier averages in a formula. In this case, that could be tricky (as taking the sum of a bunch of sums is certainly a lot cleaner than taking the average of a bunch of averages). In fact, after poking it for about ten minutes here, I'm not sure I could do it. But, the general thrust is to step back and try to generate the same number using the base records, rather than trying to make Crystal work through your average. If you have a known and relatively small number of groups that you are taking averages over, I could do it. But, I can't come up with a generalized solution off the top of my head.

(If this looks familiar, it's just you.)