sum a summary?

[prettitoni]

Is there a way to sum a summary in CR8.5? I have a report grouped on EmpID then on Date. Using a formula, I managed to pull out the total number of hours worked on each date for this month and now I want a grand total of that....

My formula for getting the Hours for this Month is:

if Month({EmployeeWorked.DATE}) = Month(CurrentDate) and
Year({EmployeeWorked.DATE}) = Year(CurrentDate) Then
Sum ({EmployeeWorked.HOURS}, {EmployeeWorked.DATE}, "monthly")

I've tried summing the results of this formula, but it says "the summary / running total field cannot be created"

Someone please help...I'm far from a CR expert :-(

 

[pbateman]

Insert a date group based on months. Then right click on {EmployeeWorked.DATE} and Insert a sub-total grouped on the month group.