I'm trying to calculate this week's WTD sales through yesterday and compare it to the same WTD sales for last year. Our week starts on Monday and ends on Sunday and I can't quite get our numbers to tie to a check that I've built in Excel.
Here is the formula I'm using for this year's WTD sales in Domo:
SUM(CASE
WHEN WEEK(`date`,22) = WEEK(current_date()-1,22)
AND YEAR(`date`) = YEAR(CURRENT_DATE()-1)
AND DAYOFWEEK(`date`) < DAYOFWEEK(CURRENT_DATE()-1)
THEN `totalsales`
END)
Any ideas on how to fix this?