Average of Counts in a formula

[cmv131]

Hi all, Hopefully this is pretty simple.

I am trying to put together an average usage report in Crystal, with the source being an Access database. Currently working in CR10, but also have 8.5 available.

Here is what my data structure looks like:

DateEntered User
1/1/2005 12:00 pm JDOE
1/1/2005 12:00 pm ME
1/2/2005 12:00 pm JDOE
1/2/2005 12:00 pm ME

For something like 28,000 Rows. I want to know the Average of the total by hour. So I would want this to output 12:00pm --- 2

I Group on the Hours by :
Right(DateEntered,11)

I can get the totals just fine by using a sum, but is there a way I can use this to get the average by hour?

 

[Madawc]

Try a running total. They allow fancy averages, and a lot of other things. (Their drawback is that they 'run' along with the detail lines, so that you can't know the final value before you get to the group footer.)

Madawc Williams (East Anglia, UK)

 

[cmv131]

Hmm. I may have to try that.

As a work-around, I added a formula to count all the Days and all the Users, and divide them based on the group they are in. It appears to be working as I was hoping to make the average function work, so I can't complain.

Thanks for the idea