Set Analysis(Call last week)

[RK121]

Hello,

I am trying to apply set analysis on data, but can't figure out how to show sum of last week.

I have only field 'Full Week (MM/DD - MM/DD/YYYY)', I need to show Total for the last week.

The idea is this: 

=SUM( {$<[Full Week (MM/DD - MM/DD/YYYY)]={'09/04 - 09/10/2022'}>} Total

Not sure how to call for last week, found this =year(today()-7)&'/'& week(today()-7), but it's different format.

[vinieme12]

As below

sum({<[Full Week (MM/DD - MM/DD/YYYY)]={"$(=date(weekstart(today(),-1,6),'MM/DD')&' - '&date(weekend(today(),-1,6),'MM/DD/YYYY'))"} >} 1)

[RK121]

Hello, Vinieme.

Nope, it doesn't work.

When I type:    =SUM( {$<[Full Week (MM/DD - MM/DD/YYYY)]={'09/11 - 09/17 2022'}>} Total)      I got:41

                              =SUM ({<[Full Week (MM/DD - MM/DD/YYYY)]={"$(=date(weekstart(today(),-1,6),'MM/DD')&' - '&date(weekend(today(),-1,6),'MM/DD/YYYY'))"} >} Total)        I got: 0

Could you please point me to my mistake?

Thank you

[vinieme12 · Accepted solution]

just fix the formatting

=SUM ({<[Full Week (MM/DD - MM/DD/YYYY)]={"$(=date(weekstart(today(),-1,6),'MM/DD')&' - '&date(weekend(today(),-1,6),'MM/DD YYYY'))"} >} Total) 

in your original post your formatting is 

---

=SUM( {$<[Full Week (MM/DD - MM/DD/YYYY)]={'09/04 - 09/10/2022'}>} Total)

[RK121]

Works! Thank you!