I have the following requirement:
CRD Qty and Shipped Qty are my 2 quantities field coming from my source. I want to aggregate and store their quantities for a quarter in a field IHCRD Qty.
Suppose right now I'm in Wk-5. So as per the requirement it should aggregate my Qty's from current week(Wk5) till my last week of my quarter(Wk13) for CRD Qty. For Shipped Qty it should aggregate the qty's from the start week(Wk-1) till my current week - 1(Wk-4). Summation of all these Qty's will be stored to IHCRD Qty in my current week(Wk-5).
Eg - Wk5
CRDQty - Sum from WK-5 till Wk- 13 = 490.
Shipped Qty- Sum from Wk-1 till Wk-4 = 40.
IHCRD Qty = CRD Qty + Shipped Qty = 530.
This logic is restricted to particular quarter i.e Summation of a particular week will happen from the start week of that quarter till the end week of that quarter.
Any guidance or suggestions would be highly appreciated.