Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello! I am trying to create a workflow that uses the last month's [Current Ending Balance] as the next month's [Prior Month Ending Balance] that is specific to the [Tax/Internal Order] field. I have an example of what the amounts would look like. The [Current Ending Balance] = [Prior Month Ending Balance] + [Current Month Activity] for that specific [Tax/Internal Order].
Thanks!
Hey @myerkate16,
From my understanding you want to create the [Current Ending Balance] column for each tax order.
To achieve this I used the multi row formula selected the previous rows current end balance and grouped on tax order. Hope that makes sense.
