Authored by: Tianyue Wang (Terri)
YoY Growth % Calculation With SAP IBP
Use Case
Businesses need to be able to answer questions such as: “How do our Q1 numbers look compared with last year’s Q1?”, “How does our business growth compare with last year’s?” or “Has our business growth slowed down in recent periods?”. To be able to answer those questions, companies perform a year-over-year (YoY) analysis to compare recent performance to that of historical periods. This type of analysis enables users to easily see long-term trends and how the financials are trending over time.
How to Calculate YoY Growth %
Year-over-Year Growth = (Current Period – Last Period) / Last Period * 100%
We can easily build this formula in Excel when doing simple calculations, but self-based calculations are not supported in SAP IBP. For this, IBP has its own Simplified Key Figure Calculations Function – Period Shift.
To calculate our YoY Growth % in SAP IBP we will use the Period Shift using a Constant.
The Period Shift Function is mainly to create a helper to store the key figure values that you wanted to do the comparison, so the calculation of growth will happen between two key figures, which makes the configuration in one step.
The example below shows how the period shift helper (last year) matches with the input key figure (current year) and does the calculation in a straight way.
Since the request is the year-on-year growth, which is a fixed period, we can use shift by a constant function in Period Shift, which means to use a constant to define the number of periods by which you want to shift the input key figure, you can shift into future (positive integer), or shift into the past (negative integer):
IBP_PERIODSHIFT (<KEY FIGURE@PLANLEVEL>, <NUMBER OF PERIODS>, <AGGREGATION TYPE> (optional)).
IBP Calculation
Actual Sales Qty Prior Year:
ACTUALSQTYPRIORYR@REQUEST = SUM(“ACTUALSQTYPRIORYR@MTHPRODLOC”)
ACTUALSQTYPRIORYR@MTHPRODLOC = IBP_PERIODSHIFT (“ACTUALSQTY@MTHPRODLOC”, 12)
YoY Growth %:
GROWTH@REQUEST = IF (“ACTUALSQTYPRIORYR@REQUEST” = 0 OR ISNULL “ACTUALSQTYPRIORYR@REQUEST”, 0, (“ACTUALSQTY@REQUEST” – “ACTUALSQTYPRIORYR@REQUEST”) / “ACTUALSQTYPRIORYR@REQUEST”)
Planning View Display
The main benefit of YoY Growth % is that users can easily identify if there has been a positive or negative impact.
How Krypt can help you?
Krypt is an SAP preferred partner and has assisted in the success of global businesses across industries & geographies. We have helped businesses through the successful integration & implementation of SAP IBP, SAP GTS, SAP TM & SAP EWM. If your organization is regularly required to plan supply chain activities on a weekly or monthly basis in advance, then Krypt can help you implement/integrate SAP LBN to quickly analyze & respond to any scenario in near real-time using an informed decision.
Follow us on:
Image Credit: Freepik