2 Replies Latest reply on May 6, 2015 8:03 AM by philmodjunk

# Summarizing on certain day of week

### Title

Summarizing on certain day of week

### Post

We have a report that summarizes data in groups by week.  There is running total and  all is good except my week starts on a thursday ends on a wednesday.  I need to see the totals for each week this way.  I've tried different calculations but I am missing somehing.

• ###### 1. Re: Summarizing on certain day of week

David F4693:

Assuming your date field is named "DateField", create a calculation field "StartWeek" with the formula:

DateField - Mod ( DayOfWeek ( DateField - 5 ) ; 7 )

If DateField equals 5/6/2015 (May, 6, 2015), then the result is last Thursday 4/30/2015.  If DateField equals 5/7/2015 (May 7, 2015), then the result is Thursday 5/7/2015.

Let me know if you need additional clarification.

TSGal
FileMaker, Inc.

• ###### 2. Re: Summarizing on certain day of week

So your report needs a common "sorted by" value for all records dated from 5/7/1015 to 5/13/2015?

Let ( D = YourDateFieldHere + 3 ; D - DayOfWeek ( D ) + 1 )