Hello Everyone,
I'm trying to duplicate column F in Alteryx. The formula in the first row is (Amount - Finished) + Adds. In row 2 the formula is (Row 1 Amount B - Row 2 Finished) + Row 2 Adds, then (Row 2 Amount B - Row 3 Finished) + Row 3 Adds... on so on. Basically, I want to base the formula on the next row on the result from the previous row. What would be the best way to accomplish this in Alteryx?
Thanks!
Solved! Go to Solution.
Here you go - no multi-row needed
3 steps:
- create a single column that gives the overall movement on each row (finished - added)
- do a running total of this column to see overall change from the starting point
- finally use a formula on each row to subtract the running total from the amount
hopefully this solves your question - if so, would you mind marking this a solved? If you still have questions, please post them on this thread (with any additional data) and we can close this out together.
Cheers
Sean
Hi Sean,
I can't open the workflow. It looks like I'm on an earlier version of Alteryx. Can you type the formula that you used and the final result?
Hi Sean,
I can't open the workflow. It looks like I'm on an earlier version of Alteryx. Can you type the formula that you used and insert an image of the final result?
:-) there's a simple hack to get around this -- just open up an alteryx file in Notepad++ and set the version number manually. I've done this and attached the revised workflow to this thread.
Version Hack:
these are the first 2 lines of any alteryx workflow file - you can get round these version issues by changing the bold text below
an alteryx 11 flow:
<?xml version="1.0"?>
<AlteryxDocument yxmdVer="11">
Updated:
<?xml version="1.0"?>
<AlteryxDocument yxmdVer="9.5">
Thanks Sean! That worked