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 #196: Determine Profit Margin

nitinsnow
Alteryx Alumni (Retired)
Spoiler
Spoilernitinsnow_0-1578303546658.png
OllieClarke
15 - Aurora
15 - Aurora

Catching up now 🙂

Spoiler
Challenge 196.png
JamesBills
8 - Asteroid

Solved my first weekly challenge

 

Spoiler
Spoiler

Solution Final.jpg

 

DanJ3
8 - Asteroid
Spoiler
Spoiler

196_sol_DanJ3.PNG

 

huynv96
9 - Comet

 

Spoiler
196.PNG

My solution! Good challenge!

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Rounded given output to ensure my answer matched to 6 decimal places.

Capture.PNG

msouriques
6 - Meteoroid

First Challenged solved!

 

Spoiler
msouriques_0-1578323051041.png

 

DanielMS
Alteryx
Alteryx
Spoiler
Capture.PNG
Jess2
6 - Meteoroid

Here is my solution.

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution!

 

Spoiler
The key to this one was creating the quarterly groupings using Generate Rows tool + a pair of Multi-Row Formula tools. Someday I'll get around to creating a macro for the "pair of Multi-Row Formula tools" combo - I use this combination quite often when I need a bit more control over the outcome than the Tile tool provides.

WeeklyChallenge196.JPG

Cheers!

NJ