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

mraymond003
5 - Atom

Done. 

jiachern
6 - Meteoroid

First try, see my solution below!

RWvanLeeuwen
11 - Bolide

Here's my take:

Spoiler
It took me quite some time as I triend this challenge with the track pad of my laptop :DIt took me quite some time as I triend this challenge with the track pad of my laptop :D
GaurVitul
7 - Meteor

Here is my solution.

kelly_gilbert
13 - Pulsar

Great submission, @Treyson

 

My solution is similar to some of the others.

 

Spoiler
I used a datetime formula to calculate the quarter (where [Min_ContractDate] is the min for that specific client.
I assumed the quarter was based on calendar months, as the instructions didn't specify what to do if a contract started mid-month. That didn't really matter, anyway, since all of the contract dates started on the first of the month!

kelly_gilbert_2-1578186073633.png


kelly_gilbert_0-1578185890171.png
JackParry
8 - Asteroid

Solution

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Strohy
8 - Asteroid

 

I over-complicated that one, but got there in the end.

 

Spoiler
bstroh_0-1578282612085.png
delilah
8 - Asteroid
Spoiler
キャプチャ.JPG
knlekash
7 - Meteor

Solution attached