Challenge #17: Month-over-Month Retention Rate

[KOBoyle]

Solution attached. In the macro I used a slight variation from what others have shown in that I passed the control parameter directly into the Formula tool rather than passing it to a Text Input and then using the Append Tool. 

[JoBen]

Cheers!

[DavidP]

The most difficult part for me was figuring out the correct condition for defining the Open column for each year! Nice compact solution once I got that bit right!!!

I still think that it's really cool that you can update just about anything you want in pretty much any tool with the Action Tool!!!

[yavdaanalytics]

attached my solution

Spoiler

[nnilz]

Difficult to understand the question and this became more an exercise on learning about batch macros. Solution attached

[pasccout]

Here is my solution...

Had to figure out that the account still needs to be opened in the current month...

[jbranaum]

Here is my solution.

Good exercise to practice batch macros!

Thanks!

[archietao]

still have trouble using Batch Macro. Had the same problem as Challenge #11. 

Solved this without a macro but will try to figure out how Batch macro works later. 

[archietao]

Solution with a Batch Macro! 

[Karam]

Great practice!