Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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