Formula Depreciation
Hi
We need the system to calculate depre 40% for 4 yrs and STL for the last year. The Life is 5 yrs.
For year 1-4 , it should multiply with Rate= .4
For Year 5 , It should multiply with Rate =1
We define as follows:
Method Type = Formula
Calculation Basis: NBV
Life: 5 years 0 months
Formula:
DECODE(SIGN(<Remaining Life2> – 4), 1, 1, 0, 0.4, –1, 0.4)
Please advice us how to correct the formula.
We need the system to calculate depre 40% for 4 yrs and STL for the last year. The Life is 5 yrs.
For year 1-4 , it should multiply with Rate= .4
For Year 5 , It should multiply with Rate =1
We define as follows:
Method Type = Formula
Calculation Basis: NBV
Life: 5 years 0 months
Formula:
DECODE(SIGN(<Remaining Life2> – 4), 1, 1, 0, 0.4, –1, 0.4)
Please advice us how to correct the formula.
0