Last week set analysis

[#1]

How can i use the Weekstart function within a set analysis, so that only the data for last week is included? (I do not mean the last 7 days, i mean the preceding working week.) In this case, I can't adjust my master calendar so have to make do with the CalendarDate field.

This is my expression

=sum({$<Book={"EM MATCH"}>}PRICE)

I can't get my head round the correct syntax

[santharubban]

Hi try this,

=sum({$<Book={"EM MATCH"},w_date = {'$(= weekstart(w_date))'}>}PRICE)

[#3]

I assume i substitute my CalendarDate field for w_date?

=sum({$<Book={"EM MATCH"},CalendarDate = {'$(= weekstart(CalendarDate))'}>}PRICE)

this did not work

[#4]

I am unclear how your suggestion would apply to the previous working week, which is what I need

[#5]

I assume a -1 needs to be added to specify the previous week. Although this still doesn't work!

=sum({$<Book={"EM MATCH"},CalendarDate = {'$(= weekstart(CalendarDate),-1)'}>}PRICE)

[rustyfishbones]

Hi Alex,

Can you share part of the App, or some of the Data?

Al

[MK_QSL]

=SUM({$<Book={'EM MATCH'},[YourDateField] = {'>=$(=WeekStart(Today()-7))<=$(=WeekEnd(Today()-7))'}>}PRICE)

[#8]

Alan, ignoring the Book field, its just a CalendarDate field and an amount field (aka PRICE)

There are multiple amount entries for each date

[#9]

That didn't seem to work Manish

[MK_QSL]

What is the format of your Date Field?