2 Replies Latest reply: Mar 2, 2011 2:25 PM by Henry Noh RSS

    Set Analysis with Variable Dates and an Operation

      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)