Challenge #304: International Bank of Awesome Data - Part III

[Bobbyt23]

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]

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

My solution:

Spoiler

[lwolfie]

My debits/credits didn't match because I added them individually instead of by day.  

[JBevan89]

Great Challenge.  I followed along to the solution to be honest, and made a few changes that I successfully experimented with