Challenge #117: Credit/Debit Midpoints

[payam2]

It's amazing to see how many different solutions are given here. Great bunch of bright people here 🙂

[T_Willins]

If this were a workflow for use IRL I think I would spend more time to make it more elegant and streamlined, but this workflow should work for any data sets in this format.

Spoiler

[mbogusz]

Cool use of the Smart Tile tool.  Thank you @kcgreen for the inspiring solution.

Spoiler

[justindavis]

Fun one!

Spoiler

[bjkay30]

Here is my take on this one.  This one was a hard one to fully understand the problem!

Spoiler

[KMiller]

Solution attached.

Spoiler

[RWvanLeeuwen]

Pretty challenging tbh 😄

Spoiler

[nini]

My Solution:

[phottovy]

My solution ended up being similar to the given solutions except I forgot about the running sum tool. Oops.

[SueDonim]

The more of these I do, the more my solutions are becoming like those of the experts.  Always a good sign (even if I am not there yet) as I guess it is becoming more intuitive

Spoiler

Process:
- Add RecordID
- Split out even rows
- Tokenize to separate each number (\W*\d+)\s*
- Convert to number
- Take running total
- Add new RecordID
- Sort by new RecordID (desc)
- Take new running total
- Add new RecordID
- Compare running totals above and below test record
- Number Records from 0
- Change original RecordID to Account (by dividing by 2)
- Filter out Null matches
- Clean-up