Overview: In this tutorial you will learn and understand that how you can use YoY calculation in SAC with examples.
YOY (Year over Year)
(Year over Year) YoY calculation in SAC is the function which returns a percentage (%) showing the difference between the value of current year compared with the previous year. This difference in numbers show how your business is performing as compare to last year of same month. So if you are calculating YoY in July Month for 2020 then YoY% will be the same month of last year e.g YoY = July’2020 – July’2019.
Syntax:
YoY ( [account member] )
Lets understand with few examples
Example: YoY calculation between two year
Lets take below table example which have 6 year for data for TotalRevenue and we will calculate YoY for these years
YoY_New = YOY ( [TotalRevenue] )
| Sr.no | Year | TotalRevenue | YoY_New Result | Comment |
|---|---|---|---|---|
| 1 | 2010 | 10,000 | undefined | error because it’s the first year |
| 2 | 2011 | 14,000 | 28.6% | Ok |
| 3 | 2012 | 11,000 | -27.3% | Ok |
| 4 | 2013 | 0 | -100% | Ok |
| 5 | 2014 | 13,000 | undefined | error because previous year’s TotalRevenue is 0 |
| 6 | 2015 | 12,000 | -8.3% | Ok |
| 7 | 2016 | 14,000 | 14.3% | Ok |
Explanation of above table
Row 1 give the error because because it’s the first year in the dataset and YoY formula don’t able to find out the compare year.
Row 2, 3 6 and 7 give the correct YoY5 value as both current year and previous year have the valid value
Row 5 give error because previous year have the zero value
This YoY calculation in SAC can be used in table view and chart view like combine chart where you can show actual and YoY presentation in single chart.