Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
PFA
The solution would help you out......
Regards
Nitin
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.