I am using google data studio and I am trying to create a calculated field using a case
statement, but it is not working. The metric is sales. Bellow is the sample line:
CASE WHEN SUM(sales) > 350000 THEN 1 ELSE 0 END
The formula above gives me an error. If I do the formula bellow instead it doesn't give an error but the result is not what I expect:
CASE WHEN sales > 350000 THEN 1 ELSE 0 END
Any idea what could be wrong ? I tried to use if
as well without success.