We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #117: Credit/Debit Midpoints

13 - Pulsar

my solution!

15 - Aurora

Challenge #117 solved

Spoiler

14 - Magnetar

Here is my solution !

15 - Aurora

Challenge 117 is done!

Spoiler
7 - Meteor
Spoiler

9 - Comet
Spoiler

Did a lot of faffing not knowing how to tackle this challenge, but got there in the end. A fantastic learning opportunity!

10 - Fireball
Spoiler
14 - Magnetar

My solution.

Spoiler
My first workflow is very many tools, so I tried 2nd challenge.

I tried to new workflow.

I use Dynamic Replace tool in Batch Macro.

Spoiler
Batch Macro

Workflow

17 - Castor

Spoiler
Alteryx

Nice little problem to solve!

I went for a simple formula to identify the midpoints. Some prep around and it works.

Spoiler

solution idea:

1. sum all
2. running total
3. if running total = sum - running total - next transaction