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.
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
This works great! Thank you so much!
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?