Find a specific word from a "Array Join" field.

[Abraham_Bochner]

Seeking to identify if two numbers match exactly in both fields, such as 22 matching 22, and not partial matches like 2.

[Sho · Accepted solution]

How about REGEX?

REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")

[Abraham_Bochner]

Thank you greatly, this is precisely what I aimed to achieve.