2 Replies Latest reply: Sep 15, 2017 7:52 AM by kiran kumar RSS

    I have a scenario that  i have fields called STARTDATE and ENDDATE,  i need to calculate only CurrentWeek, Nextweek and Next following Week (eg: current week 37, need to show data only for 37,38,39) excluding Weekends

    kiran kumar

      Hi Experts,

       

      i have a scenario that  i have fields called STARTDATE and ENDDATE,  i need to calculate only CurrentWeek, Nextweek and Next following Week (eg: current week 37, need to show data only for 37,38,39) excluding Weekends

       

      For example:

      I have a data for

      startdate,enddate, value

      13/09/2017,26/09/2017,7

      06/09/2017,27/09/2017,5

       

      WEEK is filter:

      my calculation should be

      Current week= in this week remaining days(3)= 7*3= 21 and 5 *5= 25  total =21+25=46

      Nextweek= in this week remaining days(5)= 7*5= 35 and 5 *5=25  Total=35+25 = 60

      Nextweek= in this week remaining days(2)= 7*2= 14 and 5 *3=15  Total = 14+15= 29

      like this

       

      Thanks

      Kk