Calculating and scheduling out depreciation by year
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to schedule out depreciation by year using MACRS. I need to be able to switch between having Bonus depreciation and no Bonus. Then I would sum up the calculated bonus by year. I can do this in Excel with an array but am not sure how to do so in Alteryx. Here's an example of what I am trying to do using Excel. Any help would be appreciated.
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @nguyenrp ,
if I got it right, you can calculate this using an analytic app to allow to switch between Bonus/Non-Bonus option.
Start it using "Run as Analytic App".
Let me know if it works for you.
Best,
Roland
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This works great! Thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I do have one question. When Bonus is selected the output displays Bonus correctly but when looking at the browse tool it only shows the non bonus output. Would you know why there is a disconnect between the two?
