Challenge #117: Credit/Debit Midpoints

[Dani_Lin]

solved

[Hammad_Rashid]

[tristank]

P A I N

Spoiler

[asultanov]

Spoiler

[Rob-Silk]

Solution attached below - not the prettiest or most efficient solution but it works; probably should have used a macro instead

Spoiler

[Tgigs]

My solution attached.

I reviewed the posted solution to understand how to solve it, because to me the instructions were not very clear. For my solution I copied the posted solution and added commentary for the tools, to show my understanding of what is happening in the workflow.

[mgaronson]

Spoiler

 Struggled to figure out how to do this, then came upon a forward/backward idea that worked out. 

[BSilverblatt]

Thanks for the challenge! Here's my solution:

[Bobbyt23]

Took me a while to work out how to do what was being asked. Great challenge.

[Carolyn]

Solved! That was a fun one

Spoiler

I assigned the Transactions a Transaction ID based on their order. I then found an Ascending Running Total and a Desc Running Total, joined on the Transaction ID, and filtered for where the 2 Running Totals were the same. I'm really happy with that solution