This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.
Hello @peerapongt ,
For me it is the first 27 invoices