Straight Line Depreciation spread issue

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.

Accepted answers

All comments

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

TejasDoke

@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

Quick Links

Can you help?

Unanswered questions

Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
How to get live small project for learning more.
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.