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

    Compare ongoing week with the previous week

      Hello,

       

      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?

       

      Thanks

       

      Tom