Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #425: Weekly Allowance Distribution

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hello Maveryx,

 

After a two-week hiatus from our weekly challenges, while we all attended Inspire, we're back to our regular routine! I hope you enjoyed your break!

 

A solution to last week’s challenge can be found here

 

This challenge was created by @Qiu and inspired by a question posted in our Community. Qiu, your contributions are priceless, and we cannot thank you enough!

 

The dataset contains a single column with the total monthly allowance for each person in a group of five teenagers. In an effort to budget their money, they want to determine how much, if anything, they would have left over if they budgeted $150 of spending each week for the first four weeks of the month.

 

Your task is to allocate the money by dividing each teenager’s total amount over five columns representing each week of the month plus a carryover week (Week 1, Week 2, Week 3, Week 4, Carry_Forward), considering their weekly spending limit [$150]). Any remaining funds after the first four weeks should be rolled over into the Carry Forward column.

 

Need a refresher? Review these lessons in Academy to gear up:

 

Good luck!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

 

Spoiler
But when Amount is 1,000, I don't know reason why the sample output is 250. My answer is 400.

スクリーンショット 2024-05-21 001757.png

1,000 - 150 * 4 = 400

スクリーンショット 2024-05-21 001821.png

 

 

mmontgomery
11 - Bolide
11 - Bolide

C425. Slightly different answer than provided.

Spoiler
c425.png
emmaob98
7 - Meteor
Spoiler
Spoiler.png
jsifontes
7 - Meteor

Here's my solution!

Spoiler
image.png
balajilolla2
9 - Comet
Spoiler
Solution Attached

Screenshot 2024-05-20 094555.jpg
JamesCharnley
13 - Pulsar
Spoiler
image.png

Unfortunately don't see a reason why this needs to be dynamic

braveraj
11 - Bolide
Spoiler
Weekly Budget Workflow.pngBudget Results.png
ggruccio
ACE Emeritus
ACE Emeritus

I think same as others I have 400 for the final person.

 

Spoiler
Simple use of one formula tool.425.png
ed_hayter
12 - Quasar
Spoiler
Good challenge