2 Replies Latest reply: Aug 21, 2015 11:48 AM by tom vervoort RSS

    Compare ongoing week with the previous week



      so I've been using this expression to monitor my Sales for the ongoing week (orderdate is my time stamp)


      Sum({$<OrderDate = {">=$(=yearstart(Max(OrderDate)))  <= $(=(Max(OrderDate)))"}>} Sales)


      What I would like to see is the figures of the week before up until the same day of the week.


      In the example below on Wednesday 10/1 I have had 120€ in sales for the ongoing week


      What I would like to know is what expression I can use to have the sales of last week up until Wedneday


      Using the example below I'm looking for 80 € (sales of 1/1 until 3/1)

      Can anyone help?