Can anyone see what I am misunderstanding about this formula?
Count({ARRELATIONSHIP.ARRELID},{CTCALLLOG.CTCLINITDT},{CTCALLLOG.CTCLINITDT}= CurrentDateTime-DayOfWeek(CurrentDateTime)-28)

I am receiving a message that highlights the final part and says that the group function must be a string.



Extra info: What I was trying to do was get a report that shows us a count of calls per day for each client, down in a list, subtotalling each week for the last month. I want to make this report go across the page left-to-right instead. So i made 4 sub reports that all worked perfectly but when I put them in my main report it didn't work. So now I am trying to make a formula that will work out each day and put one for each day, jsut changing the final number on the end of the formula.

Edited by martinbanks - 21 May 2012 at 8:05am