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

Brian32
Asteroide

Challenge Solution:

Saqueador
Brian32_0-1660765606795.png

 

This one was pretty tough, had to peek into the solution.

Saqueador
Macro.png




Workflow.png

ggruccio
ACE Emeritus
ACE Emeritus

For some reason I had different debit and credit amounts, but still arrived at the correct totals.

 

Saqueador
ggruccio_0-1661373173949.png

 

Abiramm1
Asteroide

Bit crammed but we got there in the end :)

Saqueador
Abiramm1_0-1662028412291.png

 

JamesCharnley
Pulsar
Saqueador
JamesCharnley_0-1662824423323.pngJamesCharnley_0-1662824668482.png

 

 

This actually ended up being one of the challenges I've struggled the most with trying to deal with that daily avg. Think I got there in the end after admittedly checking a couple of screenshots in the comments, bit hard to tell though with the output differences as others have mentioned!

FrederikE
Pulsar
Saqueador
FrederikE_0-1664611905796.png

 

Sashikumar
Asteroide

Learned

ZacharyRyanTIL
Asteroide

nice

gerda
Asteroide
Saqueador
challenge 304 p2.png
Saqueador
challenge 304 p1.png


Here's the solution, it was quite hard!

OzlemSigbeku
Asteroide

Well, numbers don't match and I still don't know what the Average Opening Balance is being calculated on, but I got the batch working and the outputs outputting. 

Saqueador
OzlemSigbeku_0-1668554258607.png
OzlemSigbeku_1-1668554834260.png