Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try like this
For Current Week:
Sum({$<OrderDate = {">=$(=WeekStart(Max(OrderDate), -1)) <= $(=Date(Max(OrderDate)))"}>} Sales)
For Previous Week:
Sum({$<OrderDate = {">=$(=WeekStart(Max(OrderDate), -1)) <= $(=Date(Max(OrderDate), -7))"}>} Sales)
Hope this helps you.
Regards,
Jagan.
the expression for previous week gives the entire week, I'm looking for something more complex.