Skip to Content
Apr 13, 2020 at 05:36 PM

Crosstab running average

56 Views Last edit Apr 13, 2020 at 07:09 PM 2 rev

I am trying to create a running weekly average based on the Total in a Crosstab, but can't figure it out.

(I had originally posted this with a different type of average, and now this has been corrected!)

The average would be calculated by the number of weeks, rolling forward as new weeks are added to the report. (Running Total of

Appointment Counts/Number of weeks)

Example: (see table)

1st week: 4/1 = 4

2nd week: 6/2 = 3

3rd week: 10/3 = 3.3

4th week: 20/4 = 5

And so on, for each upcoming week...

Any help is greatly appreciated!