Free Trial

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 #304: International Bank of Awesome Data - Part III

Bobbyt23
12 - Quasar

Struggled getting the total numbers to match on my first go so ended up using the solution as a walkthrough to understand how to do it properly.

Carolyn
12 - Quasar
12 - Quasar

Solved. I think there's an error in the solution file - within the Macro, the Multi-Row Tool #16, which calculates the Daily Balance - it needs a Group By "Bank Branch ID". What it's doing now is combining all the $$ into a single Daily Balance which is causing some weird Avg_Daily Balance amounts in the answers

 

The issue in the solution: 

Spoiler
2024-12-03_12-46-26.png

My solution:

Spoiler
2024-12-03_12-42-50.png

2024-12-03_12-43-02.png