Checking (SumIf) until current row

[katrinalyons]

Hello, 

I am currently trying to streamline a set of 4 formulas that need to be run on a detail containing tens of thousands of lines -- I hope that I can finally stop crashing my excel every time this process needs to happen! I attached an example; the highlighted columns are the formulas I use, although truly I just need the Formula 4 output for my work. That being said, if someone could help me achieve this Formula 4 value in Alteryx that would be great! I will also still need the data in the original form (i.e. I need the output from Formula 4 to still be associated with all the other data in that row).

I keep running into issues trying to replace the SumIf portion of my formulas, since they are checking only the rows up until the current row. I have seen solutions on here for SumIf in general, but haven't yet found one for a SumIf for only the data until the current line. 

Any help is much appreciated!

[dataguyW]

You can sort your data and try a running total.   You may need a formula to adjust your output.

[davidskaife]

Hi @katrinalyons 

Here is a worked example for you, that calculates all formula fields, using a Running Total tool as suggested by @dataguyW 

Main thing to point out is grouping by Formula 1 on the Running Total to replicate the SUMIF