Function @SLN Does Not Work Correctly
I have attached a spreadsheet show how it works and how it needs to work.
Below works:
DEPR = @SLN ("COST_BASIS","SALVAGE_VALUE","YEARS_OF_LIFE","FY11":"FY12") ;
Below does not work.
DEPR = @SLN ("COST_BASIS","SALVAGE_VALUE","YEARS_OF_LIFE","PURCHASE_DATE":"END_DATE") ;
In a real world situation, business consolidations can start in any month.
If purchase date is 7/1/2011 and end date is 6/30/2012, the result should be a full year of depreciation.
@SLN does not seem to be able to read dates, unless there is a way to flag it.
0