Add values within column up to a limit

[miguel_garci12]

Hello all

Having a unique problem to solve here, i was wondering if someone here can help me...

So i have two columns of data, which looks like this. the left side is how it is now, i want to make it look like how it is on the right side. so the values are different for a certain set of repeating column one entries. i want to add the values up until it reaches 70, if it crosses 70 then it should be a separate entry.

example: if it is A-20,A-30,A-20 then it should become A-70 but if it is B-20,B-40,B-20 then it should become B-60 and B-20 because 80>70.

Is there any function/tool i can use in alteryx to get this done ?

[Thableaus · Accepted solution]

Hi @miguel_garci12 

Here's a way of doing it using the Multi-Row Formula Tool.

WF attached.

Remember that the logic will use the sequence of rows.

Cheers,

[miguel_garci12]

Worked flawlessly! Thank you so much for your assistance, it was very fast and perfect for my needs. Thank you!