# Weekly Challenge

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

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

Submit Feedback
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.

## Challenge #196: Determine Profit Margin

16 - Nebula

Thanks for the challenge @Treyson - nice way to start the year!

Spoiler
Not much here that's controversial - only thing to point out is the gap-check to look for missing quarters ( @Treyson was kind, no missing quarters in this exercise).

Alteryx

My solution:

Spoiler

Alteryx Certified Partner

What a nice challenge @Treyson, I was really out on a limb here

Spoiler
So while I was stuck, I noticed that some have used the Tile to solve this, and it gives a much simple solution.
However, I am not so sure that the Tile approach would work unless there is only one date per client per quarter.
So my messy solution ended up looking like this:

Still Climbing
/Thomas

Alteryx Partner

Nice way to get back into the flow after winter vacation!

I took a more drawn out approach and created a macro to assign the Quarter each record, which after seeing some of your spoilers, was way too complicated of a solution.

Spoiler

Alteryx Partner

Probably used too many tools, but a straightforward solution still gets the job done!

Spoiler
16 - Nebula
Spoiler
5 - Atom

Solved!

Alteryx

12 - Quasar

Had to challenge myself on the logic!

Spoiler
Really wanted to avoid converting to a date, but using min on the date prior to converting produced bad results.
8 - Asteroid
Spoiler