Weekly Average

[newbie0423]

Hello Experts,

I am using Crystal XI and am creating a report to show the number of operating rooms procedures performed on a weekly basis and the average number done per week. I've done a count on the procedures and need some help finding the average.
(example)

1/27/2013 Number of cases 235
2/3/2013 Number of cases 231
2/10/2013 Number of cases 232
2/17/2013 number of cases 280

I would like to find the average of the total cases.

Thanks in advance for your help!

 

[newbie0423]

Hello,
I used the following formula from a previous post to get a weekly average and it seems to be working fine for 5 days but sometimes our rooms are opened on Sat and Sun so I would need to divide by 7


Count ({v_basic_case_rec_data.cr_urn}, {v_basic_case_rec_data.cr_prdate},"weekly") / distinctcount({v_basic_case_rec_data.cr_prdate}, {v_basic_case_rec_data.cr_prdate},"weekly")