4 Replies Latest reply: Oct 5, 2015 9:57 AM by RSS

    default

      Hi Guys,

       

      is there any issue with rolling 6 weeks logic of mine. it works fine sometimes and sometimes does not work

       

      ='("' & concat({<MonthAndYearID={">=$(vprevweek)<=$(curweek)"}>} distinct WeekAndYear,'"|"') & '")'


      $(vprevweek)=max(MonthAndYearID)-20
      $(curweek)=max(MonthAndYearID)-17

       

      Same logic works when i click the button of rolling 6 weeks but on open of document i kept same logic so that on open of my dashboard rolling 6 weeks get selected. but it does not work there. any idea?did you face any such issues with rolling week concepts?