community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Iterative macro for sample selection

Hi guys,

 

I am trying to build an alteryx macro to keep selecting high amount records until certain criteria is met. 

 

In the attached example, I want untested population to be less than $15 million (Criteria) and in order to do that we need to select the first 24 invoices.

 

Could anyone please help?

Alteryx
Alteryx

I do not think this needs to iterate, but correct me if I am off on what you want.  This sounds more like a rolling sum that can be done with the Multi-Row Formula tool.

 

You can find some more info on Iterative Macros and the Multi-Row Formula (my favorite) Tool in these links.

 

See attached.

Scott Jones
Strategic Sales Engineer
Alteryx, Inc.
Alteryx Partner
Alteryx Partner

Hello @peerapongt ,

 

For me it is the first 27 invoices

Untitled.png

Labels