5 Replies Latest reply: Feb 3, 2016 7:20 AM by pavan ch RSS

    Week to Date Calculation using set analysis

    Sudhir Kumar

      Hi all

      As per my knowledge i wrote this statement but it's not working fine as I expected.

      I want to find the sum of the value where the date is between starting and end of the weeks date.

       

      =Sum({<dtmdate={>=WeekStart(Today()) <=WeekEnd(Today())}>}Value)

       

      Please help to resolve or if you have any other solution for doing this please suggest.

       

      Sudhir,