Calculating and scheduling out depreciation by year

[nguyenrp]

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.

[RolandSchubert · Accepted 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

[nguyenrp]

This works great! Thank you so much!

[nguyenrp]

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?