Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
sum({<Week={$(=Max(Week)-1)}>}Sales)
try
sum({<DateField = {">=$(=Date(Max(WeekStart)-7))<=$(=Date(max(DateField)-7))"}>}Sales)