Calculating and scheduling out depreciation by year

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.

Bonus DDA.xlsx

Workflow

Accepted answers

RolandSchubert

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

CalculateDepreciation.yxwz

All comments

RolandSchubert

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

CalculateDepreciation.yxwz

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703