# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

## Challenge #196: Determine Profit Margin

Highlighted
Fireball

A solution to last week's challenge has been posted here

This week's challenge comes to you from ACE @Treyson - Thank you for your contribution!

Determine the profit margin for your company based on the number of quarters they have been a customer of yours. Read the directions carefully and use the hints as needed.

Highlighted
Asteroid

Solved!

Spoiler
Highlighted
Alteryx Certified Partner

Really nice challenge.

Spoiler
Highlighted
Meteor
Spoiler
Attached is my solution

Spoiler
Asteroid

Hi! Here my solution

Happy New Year!!

Spoiler
Highlighted
Comet

That was a fun challenge, @Treyson - I never thought about quarters that way!

My solution:

Spoiler
I struggled a bit to come up with a good way to get the Quarters number, but ended up using datetimediff and converting it to quarters.  I think it would have had to have been a lot more complicated if the dates weren't all the first day of the quarter.

Highlighted
Alteryx Partner

Spoiler
Highlighted
Alteryx

Here's my solution. Nothing fancy.

Highlighted
Asteroid

Highlighted
Meteor

My solution.

Spoiler