Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Year on Year, perhaps?
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
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:
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,
can u give me some sample expression on this if possible
Did you check this?
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.