Multi-Row Formula Help

[savannahyu]

I'm a beginner with Alteryx.
Can someone please help explain how can I use Multi-Row Formula to create running totals.
Also, how can Multi-Row Formula be used to replicate SUMIF formula in Excel where the range and sum range is dynamic (i.e. in the form of running total)?
Can someone please help?

Thanks

[danielkresina · Accepted solution]

Hi Sevanna,
There's actually a running total tool under the transform tool group.  It's the icon with a guy running.

The multi-row formula could also be used by taking the value of the subtotal row above plus the value of the current rows data (i.e. Total dollars Row-1 + Dollars).

Hope this helps

[golfingbadly]

Thanks so much for this suggestion as it worked perfectly for what I was trying to do as well.