Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
SUM({$<Date={$(=Date(Max(Date)-7))}>} MonetaryValue)
Max() will return a number, not a formatted date
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)