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