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
A solution to last week’s challenge can be found here.
Each IBAD bank branch reports data up to their Assistant to the Regional Manager, and we’ve been tasked with helping them out with this data reporting (acting as Secret Assistants to the Regional Manager, if you will). The Assistant to the Regional Manager is determined by a combination of Region and the first 3 digits of the Bank Branch ID, with the mapping file provided. All Assistants to the Regional Manager want to receive the same summary statistics by branch – Opening Balance, Debits, Credits, Ending Balance, Avg Daily Balance, % Change, and Count of Customers throughout the month.
Should you choose to accept this challenge, your task will be to create a batch macro that will generate customized individual output data sets for each Assistant to the Regional Manager, summarizing these metrics by Bank Branch as well as overall for each Assistant to the Regional Manager.
- Step 1: Identify the Assistant to the Regional Manager for each Bank Branch based on Region & the first 3 digits of the IBAD Bank Branch ID
- Step 2: Create a batch macro ** that will calculate the required metrics by bank branch as well as overall for each Assistant to the Regional Manager
- Step 3: Output should be a unique YXDB file for each Assistant to the Regional Manager with all the metrics for their branches (refer to the format in the output example)
HINT: To calculate the avg. daily balance, you will need to add daily debits/credits, including $0 on days where there are no transactions. Generate Rows tool + Multi-Row field will likely be your friends here…
** Yes, we realize you could also probably do this without a batch macro, just by using some of the grouping functions within various tools… but that’s not as much fun, is it?? **
Fun challenge!
Batch Macro Interior: 
All,
4 Joins
1 Generate Rows
5 Formula Tools
6 Summarize Tools
6 RecordID Tools
-My numbers did not come out the same as the authors....
My numbers were also slightly different for Avg Daily Amount. Looking forward to seeing the official solution.
