YOY?

[Anonymous]

Can any one explain what  we are showing for YOY Exactly?

if possible some basic expressions

I have seen the other threads also but with out knowing the basic I did't understand it ?

[ThornOfCrowns]

Year on Year, perhaps?

[Anonymous]

let me give some data like I have data from 

01/01/2015 to   03/26/2016 .

I want show YOY calculation then  what I have to show exactly  ?

I have one more field called sales allso

[santiago_respane]

Hi,

i think "YOY" means Year Over Year and it measures growth, for example, how much your sales have increased or decreased over the last twelve months.

Calculation:

1. Subtract last year's number from this year's number. That will give you the total difference for the year (If it's positive indicates a year-over-year gain otherwise a loss.
2. Then, divide the difference by last year's number.
3. The resulting number represents the year-over-year growth rate.

Example

Last year sales 1,500,000.00

Current year sales 1,700,000.00

1. 1,700,000.00 - 1,500,000.00 = 200,000.00 (indicates a gain)

2. 200,000.00 / 1,500,000.00 = 0.13

3. 13% it is your YOY evolution trend

Hope this helps.

Kind regards,

[Anonymous]

can u give me some sample expression on this if possible

[Anonymous]

Did you check this?

Year-over-Year Comparisons

[jagan · Accepted solution]

HI,

Try like this

=(Sum({<Month=, Date=, Year={'$(=Max(Year))'}>} Sales) - Sum({<Month=, Date=, Year={'$(=(Max(Year) -1))'}>} Sales))/

Sum({<Month=, Date=, Year={'$(=Max(Year))'}>} Sales)

Hope this helps you.

Regards,

Jagan.