### Title

Weekly Totals in a Subsummary Report

### Post

Hi all,

I have seven cDateSat etc for each day of the week on a Leading Subsummary which is calculating correctly for each day of the week, but I cannot get the Weekly Totals for each row to generate correctly. I've attached a screen shot of the layout. I've tried a bunch of different functions, summaries and counts, but cannot get anything to total correctly.

Thanks,

Emmett

Thanks, this detail is key:

Each column is a different field in the Report table.Define a calculation that sums the individual fields of every column, then define a summary field to total this calculaiton field and you'll get your weekly total.

cRecordTotal: Sum ( cClosedByDateSat ; cClosedByDateSun ; cClosedByDateMon ; cClosedByDateTue ... //and so forth )

sWeeklyTotal would then be the total of cRecordTotal and you can put it in your sub summary part.