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 #39: Trouble Shooting a Broken Macro

Waynemk
8 - Asteroid

and another

dsmdavid
11 - Bolide

May have gotten distracted and reworked the macro instead of fixing it :-S

Spoiler
39-2.png

also, I had troubles understanding the wording:

For example, for June 2013, the denominator would be the total number of accounts open between June 1, 2011 and May 31, 2013. The numerator will be total number of accounts closed in June 2013 or between June 1, 2013 and June 30, 2013. 

 

But it seems they are using as numerator the accounts closed in June 2013 and open before June 2013

 

Spoiler

So, instead of:

DateTimeYear([Month]) = DateTimeYear([Close_Date]) AND DateTimeMonth([Month]) = DateTimeMonth([Close_Date])

This:

DateTimeYear([Month]) = DateTimeYear([Close_Date]) AND DateTimeMonth([Month]) = DateTimeMonth([Close_Date])  AND [Open_Date]<[Month] 

39.png

 

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

CHarrison
8 - Asteroid

This turned out to be more fiddly than I expected! 

asabau
8 - Asteroid

Got it!

maxjohnson02
8 - Asteroid

It took me wayyyy too long to figure out the issue with the Append tool Warn/Error setting, but I finally got there.

daniel_ferreira
8 - Asteroid

Follow my solution package attached...

KOBoyle
11 - Bolide

Solution attached.

justynam
8 - Asteroid

My solution

 

Laurap1228
11 - Bolide

This was a fun one!

Pic of my fixed up Macro:

Spoiler
challenge39.jpg