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

[vladimirt94]

My solution 

Révélation

 

[HirokiT]

Révélation

Révélation

Solution with filter to separate  high/low thresholds

 

[Ray_Pospisil]

SQL and Alteryx result 

[RWvanLeeuwen]

here's my take

workflow

Révélation

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

Révélation

just apply the formula string I prepared in the workflow

[ahsanaali]

Révélation

 

[adamweaver39]

Suspiciously easy

Révélation

[anggapramana]

Révélation

it's fun, thx for the challenge.

[gjjadhao]

Révélation

Solution is attached 

[MatteoReddavide]

My solution

Révélation

[Djforesman]

Révélation

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