Hi Folks,
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.
Regards,
Shubham
Hi,
Please explore IBP_CAGGR function for key figure calculation.
You can aggregate data of CRDQty in one key figure at Qtr level and bring it at week level. Similarly, you can aggregate data of Shipped Qty. If required, make use of IBP_PERIODSHIFT function to bring last quarter data to current quarter. Finally, aggregate it into IHCRD Qty key figure.
Hope this helps!
Regards,
Piyush
Add a comment