Switch statement bringing back null values and can't work out why

[ElleWallace]

o

[caltang]

Please provide relevant sample/dummy data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well if possible. If not, kindly ignore.

To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy.

[ElleWallace]

Unfortunately data is a no no as it is client and confidential

[Prometheus]

@ElleWallace Can you provide a sanitized (a.k.a. fake/dummy) dataset that has the same issues as you're trying to fix? That's common practice here, as it is much easier to solve a problem in practice than it to solve it in theory.