Calculating Total growth Rate

Anonymous — Tue, 24 Oct 2017 12:10:36 GMT

I want to calculate total growth rate... What will be the expression to calculate the same?

I am using following expression :-

=num(

(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value]))))

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])),

'#,##0%')

But by using this expression I am getting total growth more than 100%.

What may be the reason behind the same?

topic Calculating Total growth Rate in QlikView