I have a little calory counter application and I'm trying to write a report that can give me an daily totals and weekly averages of the daily totals.

The daily totals are working fine with subsummary reports, but I can't seem to get the weekly averages per day to work.

I keep getting the average of all the foods entries, not the average of all the daily totals.

My mind seems to be in a fog about this...

Any suggestions?

Thanks,

Michael

Edited August 15, 200817 yr by Guest

Have you tried the GetSummary function?

I have. And I get the same result as a normal average...

I have the following fields:

Date_d (date)

WeekDayOne_cd (calculated date, first day of week)

Points_n (number)

Points_sum (total of points_n)

Points_avg (average of points_n)

I've tried to create Points_WeekAvg in a few different ways, by using both Points_sum and Points_avg as the summary field, and Date_d and WeekDayOne_cd as the break field.

Nothing seems to work...

Thanks,

Michael