AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5.4K members online now
5.4K members online now
Ask questions about Data Studio
Guide Me

REGEXP_MATCH (Sum if matches the string)

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hello Team,

I want to sum if two values matches in a particular column.

I tried with REGEXP_MATCH but it doesn't work with 

REGEXP_MATCH(Status, '(Hired | Confirmed)');

How to use Or here to sum if value is "Hired" Or "Confirmed"?