Workaround for not being able to use calculated field in a CASE statement

Question

I'm trying to create a field that only calculates when another calculated field is >= 100%. But when I try CASE WHEN Performance >= 1 THEN Product Count * 20 ELSE 0 then it says Invalid Formula. Is there a workaround for this?

Answer 1

Thats because you cannot use a formula in a then condition. Instead you need to create a calculated field that contains product count * 20. Then you can use that field as value of the then condition.

Read more here: https://support.google.com/datastudio/answer/7020724