4 Replies Latest reply on Jul 31, 2018 4:47 AM by Jagadesh Selvamani

    Regional Year on Year Sales Growth Analysis

    Jagadesh Selvamani

      Attached Image1 is showing Year over year growth based on some rules.


      Rule No 1:

      If any year does not have sales, then YoY growth for following years should be NULL.


      For example, in Central, 2016 does not have sales so 2016 onwards till 2008 there is no year over year growth.

      Similarly, you can see South, 2014 onwards and West 2015 onwards YOY is empty.



      Rule No 2:

      While calculating YOY if there is not data for previous year then, you need to use before previous year data.


      For example, in west region, 2016 we don’t have sales in 2015 so I took sales of 2014 and then calculated YoY.

      ((128-81) / 81) * 100 = 58%


      If before to previous data is not there then you can display YoY as NULL for that year.


      For Example, in south 2014 year, there is no sales in 2013 and at the same time there is no sales for 2012 also. So, YoY for 2014 is NULL.

      See one more example below, Assume I have data till 2014. I just filtered above data for this example.


      For Central 2014:

      ((157-180) / 180) *100 = -13%

      For Central 2013:

      ((180 – 196) / 196) *100= -8% (According to Rule 2)

      For Central 2012 onwards YoY is NULL (According to Rule 1)


      Kindly help with the calculation to resolved this.