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


      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.