Straight Line Depreciation spread issue

TD1

SLD-Code.png

Dear Model Builders,

As per attached screenshot of my Straight Line Depreciation code, I am not able to get depreciation to calculate and spread for all subsequent months from Date in Use to Useful Life of the asset. All I am getting is a depreciation for a month of Date in Use but not for subsequent months. I have even used SPREAD fuction as SPREAD(Purchase Price,'DEP02 Combined Asset Register'.'Useful Life (Years sys)' * 12) but it just increased the depreciation amount for Date in Use month but as above it didn't really spread/calculate the depreciation for subsequent months.

It could be something restricting the calculation or something else.

Also, I am not sure how this part of the formula really working here.

IF

                Opening Capex < PREVIOUS(Straight Line Depreciation) AND Opening Capex > 0

            THEN

                Opening Capex

Appreciate your help.

LipChean_Soh

Hi,

You can try replacing the 'DEP02 Combined Asset Register'.'Useful Life (Years sys)' in

SPREAD(Purchase Price,'DEP02 Combined Asset Register'.'Useful Life (Years sys)' * 12)

with a random number, eg 4 to represent 4 years, and see if it works. If it does, then it probably means 'DEP02 Combined Asset Register'.'Useful Life (Years sys)' has a set of dimensions that do not work with your target line item.

Thanks

TD1

@LipChean_Soh Thank you. It still didn't work.

I have also tried using only > sign instead of >= in below part of the code then I've got 0 depreciation for start period and all subsequent months too.

Feel free to share any other suggestions.

LipChean_Soh

Hi,

Are you saying it doesn't work even if you change the line item formula to

SPREAD(Purchase Price,4 * 12)

Or are you saying it doesn't work when you've only changed a part of the very long IF THEN ELSE formula?

If it's the latter, then i suggest you try breaking up the formula, and test each part one by one.

Thanks