Week vs. Week

[Anonymous]

Hello,

Trying to compare week to date vs. previous week to date.

I have a text box set up which displays the sum of "Sales" for week to date but not sure how to add an additional text box which displays the previous week to dates performance performance.

Cheers

Chris

[el_aprendiz111]

Hi,

sum({<Week={$(=Max(Week)-1)}>}Sales)

[shraddha_g]

try

sum({<DateField = {">=$(=Date(Max(WeekStart)-7))<=$(=Date(max(DateField)-7))"}>}Sales)