To calculate growth% for two years

[Anonymous]

Hi All,

I want to calculate growth% for consecutive two years

expression for current year

=sum(if(Sold_Date <= MakeDate(2018,month(To),day(To)) and Sold_Date >= MakeDate(2018,month(From),day(From)) and [Season Code] = $(Master_CurrentSeason), quantity_sold))

-

sum(if(Sold_Date <= MakeDate(2018,month(To),day(To)) and Sold_Date >= MakeDate(2018,month(From),day(From)) and [Season Code] = $(Master_CurrentSeason), quantity_returns))

Expression for previous year

=sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_sold))

-

sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_returns))

[shiveshsingh]

What is the format for your Sold_Date? And what is the error?

[Anonymous]

I want to calcultae growth%. how to calculate that?

[Anonymous]

Hi

may be like below

growth%=(Current year Sales-Previous year Sales/current year)*100

[Anonymous]

This formula i Know but if i have two different expressions for current year and previous year can I use following formula :-

column 2-column 1/ column1

or

=sum(if(Sold_Date <= MakeDate(2018,month(To),day(To)) and Sold_Date >= MakeDate(2018,month(From),day(From)) and [Season Code] = $(Master_CurrentSeason), quantity_sold))

-

sum(if(Sold_Date <= MakeDate(2018,month(To),day(To)) and Sold_Date >= MakeDate(2018,month(From),day(From)) and [Season Code] = $(Master_CurrentSeason), quantity_returns))

-

(sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_sold))

-

sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_returns))

/

sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_sold))

-

sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_returns))

[sunny_talwar]

Do you have year or date or monthyear as the dimension?

[shiveshsingh]

What are the dimensions?

[Anonymous]

week and gender are the dimensions