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

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

Running total when Box found.yxmd