Sorry if the subject isn't clear enough. I have a series of Excel formulas that I want to translate into Alteryx and for much of what I'm calculating the multi-row formula will do the job. I'm running into problems when I need to reference across formulas and time periods, so I can't just work left to right. I've attached an example in Excel that does exactly what I want for a subset of my workflow (don't worry about the reasoning behind the formulas; I just love to put myself through pain at work). Here's a basic example of the calculation issue (more clear and detailed in the attachment):
B2 = If(C1 > 0, A2/C1, 0)
C2 = C1 + A2 + B2
So B is dependent on the current row of A and the prior row of C, but C is also dependent on the current row of A and B, as well as the prior row of itself. This isn't a great example, but in effect the columns are dependent on each other while also not being circular references (again, the attachment would be clearer than my sub-par example here).
I've tried using the CReW dynamic formula tool, but I can't get it to recognize a reference to the prior row in the formula expression (i.e. [Row-1:Charges]). I will take any reasonable ideas that could accomplish the task with decent speed (doing this on 10's of millions of rows). Thanks for any and everything!
