Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #117: Credit/Debit Midpoints

jssandom
8 - Asteroid

My solution

JoshuaGostick
12 - Quasar

My solution :)

Spoiler
challenge_117.PNG
RichoBsJ
11 - Bolide

Hi! Here my solution :)

hollyhinson
7 - Meteor

My solution

Wouter
8 - Asteroid

My solution:

Spoiler
challenge 117.jpg
ipeng
8 - Asteroid

Very straight forward with Running Total

Kenda
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
hanykowska
11 - Bolide

This was a fun one!

TonyA
Alteryx Alumni (Retired)

Here's my solution. I didn't need the transaction counts to solve the problem so I added a validation to make sure the stated transaction count matched the number of transactions just to use that data for something.

TonyA
Alteryx Alumni (Retired)

@KOBoyle That was my thought at first, but if you do a running total, you are adding the transaction to both the before and after sums so you'll get the same result. If SumBefore = SumAfter, then SumBefore + x = SumAfter + x.