Challenge #196: Determine Profit Margin

[JORGE4900]

Using the Multi-row tool to get define the quarters.

Spoiler

[ddiesel]

My solution:

Spoiler

[vitorfc]

Nice challenge!

Spoiler

My solution.

[danilang]

Nice one @Treyson.  Took a couple of read-throughs to figure out the logic required.

Spoiler

Like @kelly_gilbert, I used a formula tool to calculate the Quarter as opposed to a Tile tool. 

Ceil((DateTimeDiff([Date],[Min_Date],"Months")+1)/3)​

All it takes is one missed month by any client to throw off the Tile tool method which then bubbles up through all results.

Dan
 

[jad0575]

Good one.

Spoiler

Spoiler

[dholle1958A]

Challenge 196 solution attached

[Laszlo_D]

[ozdogand]

Looks like it's always the first quarter..

Spoiler

[PhilipMannering]

Thanks @Treyson. Good one.

Spoiler

Workflow

[nataliamiteva]

Nice challenge! Here's my solution:

Spoiler