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

Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…