Using LIKE operator in Beast Mode
I am tryign to sum values based on two criteria. This is what I have come up with but it says there is a syntax error. I am not to sure how to use the LIKE and IN operator as I could not find much info on them.
SUM(DISTINCT CASE WHEN `Travel Location` like 'Domestic' and 'International' THEN `Entered Hours` END)