Within a loop, how can i count number of rows in each iteration and have a cumulative total?

[mlauber71]

@taylorpeter55 you can use the Variable Condition Loop End node to stop a loop once a condition is met. You can use temporary table to collect the results you already have.

Stop my loop if the column sum is greater than 50% of my flow variable

@kowisoft it could look something like this. Collection the iterating values in a temporary file and appending that at each step of the loop. And then like you have already done collect the sum of the column and then make a decision to sop (or not). Maybe not the most elegant way… Just make sure to reset the temporary file. One could also automate that by using a switch catching the first iteration of the loop (I have and example of that somewhere). [image] [image]

As an alternative you can try and build something with a Recursive Loop and define an end condition.