Challenge #386: Shed Light on a Bank’s Risky Business

[braveraj]

Spoiler

[Watermark]

@ggruccio   yep, data issues.  KRI4634 & KRI9101

Spoiler

 

[ARussell34]

Great way to start off the week. I learned about the "between" function and it has been really useful, especially in this problem.

[M__K__A]

My solution is attached.  I think I did this correctly, however I have a few results that differ from the provided output.  I believe there may be some discrepancies unless I am misinterpreting the records...

[olga_strubbe]

Thank you, @hannah_malek!  This was a nice challenge.  It helped me practice my batch macros. 

Solution I:  standard workflow

Solution II:  Batch macro

[rmassambane]

386!

[Sebastian_Chaieb2]

Initially I was building my solution based on [Red_Sign] field, however it looks like there is an error with the data as it dose not match specification . So I decide to use [Green_High] when it is NULL.

My Solution below:

Spoiler

[DaisukeTsuchiya]

Spoiler

A few record didn't match with Output.

Spoiler

 

[Flo_P]

Spoiler

A strange challenge with unclear and overlapping data. If there was a lesson here, I didn't learn it.

[ed_hayter]

Spoiler

Interesting Conceptual Challenge - think if the input data was more varied it would have been more fun. In the end it was varied but not enough to irk a long-winded formula.