Next 10 weeks

[dseelam]

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

[neelamsaroha157]

May be you can use

Sum({$<={">$(=WeekStart(max(Date)))<$(=WeekStart(max(Date)+70))"}>}Orders)

You can tweek it if you want Weekend.

[dseelam]

Hello Neelam,

I am not calculating as an expression, I need it to be working on whole data model!

Thanks