distinct count for each week

[retygh45]

Using CR10, I have a performance report grouped by week. I'm trying to get a count of days in that week for totaling purposes, but I get a "group condition is not allowed here" error on my formula:

distinctcount({@Review Date}, {Review.Reviewer}, "weekly")

I'm essentially trying to get a distinct count of the days per reviewer for the week totaled, for an daily average:

number of claims / days worked that week

It works if I just divide by 5 or by 7, but if someone was out a day, then I don't want it to throw off the average.

The "weekly" condition seems to be what's throwing it off. Any help is greatly appreciated, thanks!

 

[retygh45]

nevermind, it was something silly

 

[dukeslater]

Put a distinct count of the datefield in the group footer for the week. Then put a count of the same field in the same group footer. This formula is the average:

Count({table.Datefield}, {table.datefield}, "weekly")/

DistinctCount ({table.Datefield}, ({table.Datefield},weekly")