Calculating Total growth Rate

[Anonymous]

Hi

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?