Partial Period Comparison WTD WOW

Question & Answer
,
4

Think I may have found a solution

WTD Sales = ifelse(dateDiff(truncDate('WK', {date}),${Today},'WK') = 0, {Sales}, NULL)

Prior WTD Sales = ifelse(dateDiff(truncDate('WK', {date}),${Today},'WK') = 1 AND extract('WD', {date}) <= extract('WD', addDateTime(-1, 'DD', now())), {Sales}, NULL)

WoW % Diff = (sum({WTD Sales})-sum({Prior WTD Sales}))/sum({Prior WTD Sales})