Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I need som help, I'm working on a document which should show the Sales Amount and Sales Total for Week1. of the period selected.
For example. If I choose the dates February 6th to February 26th it should show me the figures for week1 (6th till 12th) etc.
How do i do this?
I tried like this:
Sum({$<Week={">=$(=max(Week),-1)) <=$(=(max(Week)))"}>} PRICEOUT)
but that gives me the summary of the last week choosen.
Will do! I'll just need to test it some more!
Thanks again!