How to average values of a group/summarized values 1

[minifelt]

I have a report that contains hundreds of sales transaction on a daily basis. My report has 2 summaries: Weekly sum of sales and drills down to daily sum of sales, and finally drills down to the details. I would like to take the average of the summarized daily transactions Average(Sum(Day1)+Sum(Day2)+ sum(Day3...). As it is Crystal takes the average of ALL the individual transactions per day. This makes my weekly average small because the indidividual detailed transactions vary widely from a very small amount to a huge amount. Therefore, I would like to take a weekly average of the SUM of transactions per day. Please help. THANK YOU MUCH.

 

[minifelt]

The following is an example of the Sales dataset. This explains further what I'm trying to do.

Day 1
Day 1 8:00 am 5.00
Day 1 9:00 am 500.00
Day 1 10:00 am 10.00
------------------------
Day 1 Total 515.00
------------------------
Day 2
Day 1 8:00 am 5.00
Day 1 9:00 am 400.00
Day 1 10:00 am 10.00
-------------------------
Day 2 Total 415.00
-------------------------
Day 3
Day 1 8:00 am 5.00
Day 1 9:00 am 300.00
Day 1 10:00 am 10.00
--------------------------
Day 3 Total 315.00

This is what I want to do for my weekly summary:

Weekly Average = Average (515+415+315)

This is what Crystal Does when I add an average summary on the Weekly Group summary:

Weekly Average= Average (5+500+10+5+400+10+5+300+10)

How can I take the the average of the daily total? I don't want the average of the entire population for the week.

Thank you

 

[lbass]

You could use a variable like this:

//{@reset} to be placed in the week group header:
whileprintingrecords;
numbervar sumdaytot;
numbervar cnt;
if not inrepeatedgroupheader then(
sumdaytot := 0;
cnt := 0
);

//{@accum} to be placed in the day group header:
whileprintingrecords;
numbervar sumdaytot := sumdaytot + sum({table.sales},{table.date});
numbervar cnt := cnt + 1;

//{@displayave} to be placed in the week group footer:
whileprintingrecords;
numbervar sumdaytot;
numbervar cnt;
if cnt > 0 then
sumdaytot/cnt

-LB

 

[minifelt]

Thank you very much for the quick response, LB. I wouldn't have figured this out by myself. Truly appreciate your help.