Is it Possible to do a Rolling Average

[fmrock]

I was wondering if its possible to do a rolling average of a field.

For example, I have a query that pulls back the sum of payments by week. I want to create a 4 week rolling average.

Any help would be great.

Thanks,

 

[Madawc]

Crystal has running totals - see FAQ767-6524 if you're not already familiar with them. You should be able to create formula fields to do the calcuated using them.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

Hmm. I responded a year ago: thread767-1492920.

-LB