Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I don't know where to start, new requirement asking to create a bucket for next 10 weeks depending on order date, lets say every week starts with Monday and ends with Sunday
So I need to calculate sum(order quantity) for next 10 weeks
Is this possible in scripting itself so that I can create filed as weeks from Week 1 to Week 10 as values ?
Thanks in advance,
Dinesh
May be you can use
Sum({$<={">$(=WeekStart(max(Date)))<$(=WeekStart(max(Date)+70))"}>}Orders)
You can tweek it if you want Weekend.
Hello Neelam,
I am not calculating as an expression, I need it to be working on whole data model!
Thanks