Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please see attached. I need to create two expressions with reference to the latest date:
1. Sum of Sales for the current fortnight; and
2. Sum of Sales for the previous fortnight
The fortnight figures should change automatically with reference to the latest date. Any ideas how I can achieve the result?
Thanks
Hi Shamit,
Try the following:
Sales for last 14 days:
=Sum({<Date={">=$(=Max(Date)-14)"}>}Sales)
Sales for previous 14 days:
=Sum({<Date={">=$(=Max(Date)-28) <=$(=Max(Date)-14)"}>}Sales)
Thanks,
Simon
Hi Simon,
I don't think the above works . I need the figures for the fortnight periods as in the list box.
Your formula gives me the sales for the last 14 days based on the latest date.
Thanks