You need to count the groups to get average.

 

Try this formula :

 

Whileprintingrecords;

numbervar x;

x:=x+1  // place this on your group

 

and create one more formula to get average :

 

Whileprintingrecords;  // Place this formula where you want to show average.

numbervar x;

{YourTotalTickets) / x;

 

 

Whileprintingrecords;  // Place this formula where you want to show average.
numbervar x;
if {@GrpAvgForm} / x = 0 then 0 else
{@CountTickets} / x;

 

When I out the formula in the header it counts all tickets, when I put it in the report footer it calculates a figure of 52 but checking the average in Excel the figure is 55?

 

I am trying to count number of date grups and that should devide your sum of all date tickets.

 

My first formula will increase the 'x' variable value when it encounter a new group.  So, this formula always on your group header or group footer.

 

2nd formula is going to divide sum of your tickets by count.  If you are getting devide by zero error means, placing of formulas in wrong sections.  Only you should get division by zero when you don't have any data.

 

Try this in my second formula :

 

Whildprintingrecords;

numbervar x;

if x <> 0 then {@CountTickets} / x

else

0

 

 

 

This is a running total and if you place this on report header then the initial value of the variable is always zero. So, it will not work any time.

 

It will work only in report footer.