Trouble Replicating Excel Logic - Mutually Dependent Columns

[angusfenney]

Hi everyone,

I've been struggling with replicating parts of an excel sheet that I am trying to replace with Alteryx. I am just interested in replicating the formulas for columns K and L but I'm unsure if these are possible due to the colmuns being dependent on one another.

Any help/advice would be greatly appreciated.

Thanks,
Angus

[jrlindem]

You should be able to replicate those formulas.  I would use the Running Total Tool and the Multi-Row-Formula Tool to accomplish this.  Running Total helps you get, was the name implied the running total.  The Multi-Row-Formula Tool is going to help you compare to other fields and check against previous values.

See if this gets you in the ballpark.  If not, I can build out an illustrative workflow.  -Jay

[angusfenney]

Hi Jay, 

Thanks for reaching out, I have been experimenting with these for a while but cannot get the logic exactly right. If it's not too much trouble could you take a look at building it out with my example please?

Thanks,
Angus