cancel
Showing results for
Did you mean:
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

## Challenge #117: Credit/Debit Midpoints

Meteor

Asteroid

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

Highlighted
Alteryx Partner

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

Quasar

Sledgehammer approach :-) Used nasty multi formula.

Spoiler
Alteryx Partner

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!

Asteroid

Here is my solution

Spoiler
Alteryx Certified Partner

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.

Alteryx Partner

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

Alteryx Certified Partner

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

Alteryx Partner

My solution, appeared to be similar to some posted earlier

Spoiler