Alteryx Multi-Row Formula Tool Demonstration

Download a Free Trial of Alteryx! tinyurl.com/y5alktlu
The Multi-Row Formula tool takes the concept of the Formula tool a step further, allowing the user to utilize row data as part of the formula creation. This tool is useful for parsing complex data, and creating running totals, averages, percentages and other mathematical calculations.
help.alteryx.com/current/Mult...
***********************************************************************************************
What is Alteryx?
Revolutionizing business through data science and analytics, Alteryx offers an end-to-end analytics platform that empowers organizations to break data barriers, deliver insights, and experience the thrill of getting to the answer faster. Hundreds of thousands of users all over the world rely on Alteryx daily to deliver real business results.
***********************************************************************************************
AB Data Consulting understands data challenges and equips teams with the knowledge, tools and confidence to overcome those obstacles and lead a digital transformation. Automation enables you to provide detailed process documentation, remove any key person risk, and transition away from ‘unwritten rules’ in data processing.
www.abdataconsulting.com/
Alteryx One Tool at a Time is a video series produced by AB Data Consulting for educational purposes and for use by anyone interested in learning Alteryx. To request additional tool videos, email [e-mail].

[@ChrisVallance]

You changed the "Num Rows" from 1 to 5, but you didn't explain why. I'm not sure what that option is doing, or why you changed it to 5 in that one example...

[@abdataconsulting7729]

Hi @ChrisVallance - I believe it was set to 5 so that you can see that you are not limited to only looking up/down 1 or 2 rows at a time.