6 Replies Latest reply: May 31, 2018 7:07 AM by Sunny Talwar RSS

    Previous week expression

    Stephen Edberk G

      My current week expression is

      week(Date)  as week,

       

      vWeek_1  = max(week)

      vWeek_2  = max(week)-1

       

      Sum({<weeks = {'$(vWeek_1  )'},Cal_Rep_FLAG ={1},>}Total_Call)

       

      current week is working fine

       

      my previous week is

       

      Sum({<weeks = {'$(vWeek_2)'},Cal_Rep_FLAG ={1},week=>}Total_Call)


      previous week is not working fine


      if i click any week its working fine otherwise it show full values


      help me  sunny


      thanks in advance