Want caculate Growth% in backend not in front end?

[#1]

Hi All,

I want to calculate growth% in backend only, how can write expreession at backend.

Formulae:

Growth%=((Max year Qty-Prev year Qty)/Prev year qty)*100.

Input:

Location	Year	Qty
A	2012	10
A	2013	50
A	2014	20
B	2012	20
B	2013	60
B	2014	80
C	2012	100
C	2013	40
C	2014	200

Output:

Location	Growth%-2013	Growth%-2014
A
B
C

Note;

Don't want to caculate at froent end need at backend only.

[Anonymous]

PFA

The solution would help you out......

Regards

Nitin

[#3]

Hi Nitin,

tx for response.

can u plase check my application. here i m not getting growth for 2013 year.

i used your formula.

Thanks,

Ashok.