alteryx Community

# 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.

## Challenge #425: Weekly Allowance Distribution

Alteryx

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!

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.

1,000 - 150 * 4 = 400

11 - Bolide

C425. Slightly different answer than provided.

Spoiler
7 - Meteor
Spoiler
7 - Meteor

Here's my solution!

Spoiler
9 - Comet
Spoiler
Solution Attached

13 - Pulsar
Spoiler

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

10 - Fireball
Spoiler
ACE Emeritus

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

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