Challenge #117: Credit/Debit Midpoints

[kcgreen]

The hardest part for me was understanding the request.  Once I wrapped my head around what was needed, the Alteryx workflow was pretty straightforward.

Spoiler

[joe_yang]

I tired to do it w/o the Running Total tool but it wouldn't work w/o a long massive conditional statement.  The Running Total tool keeps the workflow code-free 🙂   Here is my version to the solution

[ivoller]

Sledgehammer approach 🙂 Used nasty multi formula.

Spoiler

[joe_yang]

I like it! My first attempt was very similar but you are a better man for sledgehammering it in to make it work. 🙂 That switch function is sweet!

[mmongeon]

Here is my solution

Spoiler

[mceleavey]

Fantastic challenge. I actually struggled with this one and I feel there are better ways to do this. 

Spoiler

Mine is almost exactly the same as @NicoleJohnson and I must give her a shout out for having a much better solution at the beginning of the workflow with the use of the "Make Columns" tool. Mine used a clunky multi-field formula, so I stole hers. Shameless.

Anyway, I couldn't think of any other way to do this other than parsing to columns, getting a running total for each account, reversing the sorting, getting a running total the other way, then filtering those records where these running totals were equal.
Not very complex, but neither is my brain.

[joe_yang]

If the sledgehammer approach is fair game, here is mine:

[Natasha]

Here is my solution using a macro. Looking now at all the nice Running Total solutions, mine looks like a monster. Also felt a bit like adding some checks to the workflow so I am checking that the total number of credits/debits against the account equals to the total number of actual transactions per account.

Spoiler

[GalynaSkamrova]

My solution, appeared to be similar to some posted earlier

Spoiler