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

Regional Year on Year Sales Growth Analysis

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.

• 1. Re: Regional Year on Year Sales Growth Analysis

Hi Jagadesh,

I believe this work will help you out!

Step 1:

Step 2:

Final:

Best Regards,

YASÄ°N.

1 of 1 people found this helpful
• 2. Re: Regional Year on Year Sales Growth Analysis

Hi Yasin,

I am facing issue in creating ISNULL calculation field. Got a syntax error while using THEN function. Attached the screenshot for your reference.

Kindly help.

• 3. Re: Regional Year on Year Sales Growth Analysis

Jagadesh,

I just realized that I accidentily cropped the beginning of the calc (what a move) Just updated it, you can  check the reply post again!

Best regards

1 of 1 people found this helpful
• 4. Re: Regional Year on Year Sales Growth Analysis

Hi Yasin,

Thank you so much for quick response. I am able to bring out the Year over year growth as per the calculation but rule 1 is not applicable yet. I will require the attached result has the final result.