Hi Community,
I’m looking to build an asset depreciation workflow in Alteryx using the Diminishing Value Method. Below is the input data I plan to use for the calculation:
Depreciation Start Date Asset Cost Depreciation Rate Depreciation Method
| 31 Mar 2013 | 1,156.00 | 12% | Diminishing Value |
I’ve attached an example of the expected result.
Requirements:
Depreciation should be calculated monthly, starting from the depreciation start date, and should continue until the Net Book Value (NBV) reaches $10.
Could someone guide me on how to set up this workflow in Alteryx? Specifically, I’m looking for help on:
- Setting up monthly depreciation calculations using the diminishing value method.
- Generating rows for each month until the NBV reaches the $10 threshold.
