Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need one help.
I calculate a Difference Between Current Year Sale and Last Year like. www.kohlsfeedback.com Survey
num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},
[CALYEAR]={">=$(vCurrentYear)"}>}[_volume_SO]),'##.0')- num(Sum({$<[HSUBSEGM.descr]
={"Clinker and Cement"},[CALYEAR]={">
=$(vPreviousYear)<=$(vPreviousYear)"}>}[_volume_SO]),
'##.0')
so I m getting and answer Suppose.
This Year sale is 100 $ and Last Year sale was 50 $. so total growth 50 $.
But I want to show growth in %. In this case my Revenue growth is 50 % because it got double from last year..
@KimFerguson i guess your revenue growth is 100 perecent since it has doubled from 50 to 100.
So in general we calculate YOY change as
((Sum of current year- Sum of previous year)/ (sum of previous year ))*100