Skip to main content
D
Davy
Contributor
November 23, 2022

where I can find sample Business Rule code for straight line depreciation?

  • November 23, 2022
  • 2 replies
  • 0 views

I am trying to populate 30 months with depreciation.

So if an asset value is 300,000 $, and it is to be depreciated to zero in 30 months,  that would mean that I have to fill each month with 10,000$.

Seems like standard, simple BR that has already been written. Does anyone know where I can find sample BR code for straight line depreciation?

 

2 replies

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
November 24, 2022

You can do this with Spreading or Allocation on the Forms / Cube Views / Excel add-in, there are options on the right-click menu with much more power than a basic rule will have.

Also, look in Snippets in the helper tree you find to the left of the editor, there are plenty of examples you can copy.

D
DavyAuthor
Contributor
November 25, 2022

Tech support gave me sample code from Capital Planning for straight line depreciation:

Pasted image.png

    Terms & ConditionsAccessibility statement