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

[vladimirt94]

My solution 

Spoiler

 

[HirokiT]

Spoiler

Spoiler

Solution with filter to separate  high/low thresholds

 

[Ray_Pospisil]

SQL and Alteryx result 

[RWvanLeeuwen]

here's my take

workflow

Spoiler

there's a descrepancy between the thresholf amber field and the actual low value border, so I edited that to ensure I only get 1 result back

batch macro

Spoiler

just apply the formula string I prepared in the workflow

[ahsanaali]

Spoiler

 

[adamweaver39]

Suspiciously easy

Spoiler

[anggapramana]

Spoiler

it's fun, thx for the challenge.

[gjjadhao]

Spoiler

Solution is attached 

[MatteoReddavide]

My solution

Spoiler

[Djforesman]

Spoiler

Managed to do this with one formula
IF IsNull([Green Sign]) THEN
  IF [Value]>[Amber High] THEN 'Red'
  ELSEIF [Value]<=[Amber Low] THEN 'Green'
  ELSE 'Amber' ENDIF
ELSE
  IF [Value]>[Amber High] THEN 'Green'
  ELSEIF Value<=[Amber Low] THEN 'Red'
  ELSE 'Amber' ENDIF
ENDIF