Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following variables:
1. vLatestWeek
2. vWeeksAgo
3. vBeginWeek
Is it possible to write in an expression using these variables to sum up all the weeks from the LatestWeek to however WeeksAgo? without having to use the BeginWeek?
To further this, both of the expression below are functional but don't give the answer I need. I believe it's a combination of the two but my syntatical permutations are not working. Any help is much appreciated! Thanks in advance!
Sum({< Weeks = {'$(=$(vmaxweek) - $(vweeksago))'} >} Sales)
Sum({<Weeks={">=$(vbeginweek)< $(vlatestweek)"}>}Sales)
Hard to be sure of syntax without being able to check it, plus the variable names in your two sums are inconsistent both with each other and with the variables you listed in the post. But I'm guessing this:
sum(<Weeks={">=$(=$(vlatestweek)-$(vweeksago)) <$(vlatestweek)"}>} Sales)
Hard to be sure of syntax without being able to check it, plus the variable names in your two sums are inconsistent both with each other and with the variables you listed in the post. But I'm guessing this:
sum(<Weeks={">=$(=$(vlatestweek)-$(vweeksago)) <$(vlatestweek)"}>} Sales)
Thank you! this worked perfectly.