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..

       

      Thanks