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

deviseetharaman
11 - Bolide
Spoiler
 
JanetYang67
5 - Atom

Using "Tile" tool 

deepaprash
8 - Asteroid

Solved!

chinedu
7 - Meteor

My solution

paulfound
11 - Bolide
Spoiler
PaulFound_0-1594793761889.png

 

wwatson
12 - Quasar

my solution

johnemery
11 - Bolide

NIce, quick challenge. Thanks for the formulas!

 

Spoiler
Capture.PNG
Inactive User
Not applicable

Solved 🙂

grazitti_sapna
17 - Castor

Here is my solution to Challenge #196

 

Spoiler
grazitti_sapna_1-1598863144199.png

 

Thanks.

Sapna Gupta
JamesMA
Alteryx Alumni (Retired)

A bit rusty after not doing challenges for a while.

 

This one was tricker than it looked!

 

Spoiler
James Marks Week 196 Image.PNG
Spoiler
The trick for me was realising that you need to calcumate Sum_Cost and Sum_Revenue first before then working out a Quarterly Profit Margin. Previously tried doing it all in one tool and then calculating an average Quarterly Profit Margin but this does not give the true average!