17 Replies Latest reply: Nov 30, 2013 8:37 AM by Thomas Jensen RSS

    Sum of value by date range (last week & this week)

      Hi All,


      I'm new to QV and i want to learn more regarding the date formulas/script etc.. Can someone help me with my QV date formula?


      I have a list of submitted requests and i want to break the total value per "last week" and "this week"


      for example:


      Sum of Total by last week "from 17-Nov-13 to 23-Nov- 13"


      Sum of Total by this week "from 24-Nov-13 to 30-Nov-13"

      So for every last week and this week per month it should be calculated automatically


      I attached the sample of my excel list and my QV test..