If you are expecting it to be spread only for 24 months then mention the range also to have 24 months. Life is used to get the straight line depreciation rate where as range is used to figure out into how many years this depreciation has to be spread into.
Instead of specifying range leave it empty
I've tried to remove range, it gave depreciation (although correct) for the first year only. This is the year when investment was put in, nothing for second year while life time was set to 24 periods (2 years).
Even I am facing the same issue.
I have tried the same as they have specified in the official document, the output is drastically different. And in one of the community, I have found that @XRANGE only works correctly for a limited number of functions. I don't know whether it is true.
Exactly, I have tested it with periods within only one year and then this function works correct. But it crushes with multiple years' depreciation.
@SNL pretty much standard (Cost - Salvage / Life) So if you are trying to put in 2 years in your Life and expecting the value to be spread across 2 years that will not happen. You need to modify the XRANGE and your FIX so that it would work. In the past I have found some issues with @XRANGE with a couple of function and the position of the member on the outline but here it seems to be working fine for me. I've not had much luck with SET CREATEBLOCKONEQ ON; can you just push in some values for all the years first and then give it a try.
Please note just because I gave 2 years I doesnt mean the value is spreading for 2 years. Its because of my XRANGE in my calc in the below snapshot.
Hope it helps!
Again sorry please don't get confused with the years I mentioned that is only with reference to XRANGE but it still does calculate the depreciation with the number in Life across months
Hope it helps