on 2023 Jun 13 6:45 PM
I have a new requirement to define a new KF in IBP that calculates the Year-to-date Growth % using the folllowing formula :
YTD Growth % = (aggregated Forecasted Demand from January to current month - aggregated Order Invoiced from January to Current month) / aggregated Order Invoiced from Jan to Current month
The base planning level is : Month Product Customer
My idea is to create one Key Figure for the cumulative Consensusdemand KF (from January to current month) , same for Cumulative "Orders Invoiced" KF, using the CAGGR function like this :
CumulativeConsensusDemand = IBP_CAGGR("ConsensusDemand@MTHPRODCUST",''SUM'',''FORWARD'',''PASTCURRENT'',6)
Can you please help define the right formula for the final KF ?
I'd appreciate your help if you guys have any idea. Thanks in advance!
Request clarification before answering.
Dear Amre,
To calculate the Year-to-Date (YTD) Growth % Key Figure (KF) using the provided formula, you can define a new KF in IBP with the following formula:
YTD Growth % = (Cumulative Consensus Demand - Cumulative Orders Invoiced) / Cumulative Orders Invoiced
YTD Growth % = (IBP_CAGGR("ConsensusDemand@MTHPRODCUST",''SUM'',''FORWARD'',''PASTCURRENT'',6) - IBP_CAGGR("OrdersInvoiced@MTHPRODCUST",''SUM'',''FORWARD'',''PASTCURRENT'',6)) / IBP_CAGGR("OrdersInvoiced@MTHPRODCUST",''SUM'',''FORWARD'',''PASTCURRENT'',6)
This formula calculates the YTD Growth % by subtracting the Cumulative Orders Invoiced from the Cumulative Consensus Demand and then dividing it by the Cumulative Orders Invoiced.
Additionally, it's important to ensure that the Cumulative Consensus Demand and Cumulative Orders Invoiced KFs are defined correctly and have data available for the desired time range (from January to the current month) before using them in the YTD Growth % formula.
Note: I'm not sure there is a standard key figure named "OrdersInvoiced", but since you wrote that in your question, I tried to go over it.
Regards,
İbrahim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.