Iterative Multi Row Formula

[schenkelpat]

Hello Alteryx Community,

My team is trying to build a SIR model that we can update as data continues to come to light around COVID-19.  We keep hitting a wall because our calculation leverages data both across columns and down rows.  I need the calculation to run across to build the inputs for the multi-row.  It is necessary to run this one row at a time as the model builds.  Any suggestions on what tools might enable this iterative, looping process?

I've attached the Excel version with sample data and the desired outcome.

Thanks,
Pat

[Aaron_Harter · Accepted solution]

Hi @schenkelpat, 

You may want to try an iterative macro approach for these multi-row calculations... attached is a quick draft model.  Best of Luck!

Canvas:

Macro Interior: