Skip to Content
0
Former Member
Jul 05, 2013 at 02:55 PM

Depreciation calculation in WebI

43 Views

Dear Experts, I looked in the forum for depreciation calculations in WebI all discussion was regarding using RelativeValue function and runningsum function to cumulative calculations. Could you please give me a hit to slove below problem? Input Date Amount installment 01/03/2013 265444 11885 01/04/2013 265444 10256 01/05/2013 265444 6541 01/06/2013 265444 7040 01/07/2013 265444 12000 01/08/2013 265444 5545 Output Need depreciation calculations in outstanding column. Date Amount Installment outstanding condition 01/03/2013 265444 11885 253559 265444-11885 = A 01/04/2013 265444 10256 243303 A-10256 = B 01/05/2013 265444 6541 236762 B - 6541 = C 01/06/2013 265444 7040 229722 C - 7040 = D 01/07/2013 265444 12000 217722 D- 12000 = E 01/08/2013 265444 5545 212177 E- 5545

Please advice.

Many Thanks in advance.

Prasad