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])