YoY Formula Details
Detailed explanation and examples for the YoY (Year over Year) formula.
Year over Year returns a percentage showing the difference between the value of a member in the current year compared with the previous year.
Syntax:
YoY([<account member>])
| Year | Revenue | Revenue_YoY Result |
|---|---|---|
| 2006 | 36598 | undefined (because it's the first year) |
| 2007 | 36820 | 0.61% |
| 2008 | 0 | -100% |
| 2009 | 35220 | undefined (because the previous year's revenue is 0) |
| 2010 | 34709 | -1.45% |
Note: undefined results appear as dashes (“-”) in stories.
Example
Revenue_YoY = YoY([Revenue])