Set analysis using dates

[#1]

I’m trying to use set analysis to calculate the revenue sum for the same day the previous week using the following:

SUM({$<Date={$(=Max(Date)-7)}>} MonetaryValue)

But for some reason, I keep getting zero values returned and I can’t understand why. There is definitely revenue there and it works fine if I hardcode the date within the {}.

Thanks

[Clever_Anjos]

SUM({$<Date={$(=Date(Max(Date)-7))}>} MonetaryValue)

Max() will return a number, not a formatted date

[#3 · Accepted solution]

Thanks Clever Anjos, my colleague who was having this problem has managed to get round it using the following syntax:

SUM({$<Date={$(='['&Date(Max(Date)-7)&']')}>} MonetaryValue)