we got a problem with a personalised case statement. In a Datastudio-Report, we try to sum up two variables imported from Facebook.
Somehow, when one of the variable is 0 (or "null"), in our Report there is displayed "null", even if the other variable has data. We tried to fix that problem with a case statement but Datastudio tells us that the formula is invalid.
Here you can see a screenshot of our formula. Could you please help us?
thanks for your question.
This is a questions for Google forums, as we're not in charge of the calculated field functions.
thanks for reply, ok you're right but the problem is that the Supermetrics Facebook connector show the value "null" instead of "0" (zero). This is a problem because with the "null" value the calculated field functions doesn't working (!)