How to add running totals based on row value

[JamesBarzda]

Hi,

I'm looking for the best way to add a running total based on row values. In my screenshot below, I'd like to add a running total that increases by 1 every time the term 'Box' is found in column A. I can then filter out based on the running total value to summarise the net and vat. Any ideas how to achieve this running total column? 

Thanks in advance

JB

[DataNath · Accepted solution]

Hey @JamesBarzda, you ought to be able to use the Multi-Row Formula tool for this, with the expression below. Let us know if you run into any issues though and we can revisit!

if contains([Box], 'Box') then [Row-1:Running Total]+1 else [Row-1:Running Total] endif

[grazitti_sapna]

@JamesBarzda , My solution would be similar to what @DataNath has provided. Whenever you want to perform any row based calculations you can use Multi Row Formula tool and either update the existing field or create new field based on your requirement.

[JamesBarzda]

@DataNath and @grazitti_sapna thanks for your help, this has worked perfectly!