2 Replies Latest reply: May 13, 2013 5:14 AM by Stefan Wühl RSS

    Sum revenue for each saturday in a month

    Henco van Ee

      Hi all,

       

      In our business environment we book orders which gives us a certain amount of revenue.

      We would like to see how this revenue is growing per week, where the reference day is saturday.

       

      I would like to have a table like this:

       

       

      MonthFirst satSecond satThirds sat
      Fourth sat
      Fifth sat
      110000200003000040000
      215000300004500060000

       

      The expression is should be something like:

       

      sum(if(Bookdate <= (date of 1/2/3/4/5 saturday in a month) Revenue))

       

      In the sample document I have made an example of what I would like to see, but in my opinion the expression I use is way to complex.

      Is it possible to get the ' date of 1/2/3/4/5 saturday in a month'  with a variable or in another way?

       

      Many thanks.

       

      Regards,

      Henco