Supermetrics Support Forum

Problem with a personalised Case Statement in Data Studio

Hi there, 

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?


  • Hi Giuseppe,


    thanks for your question.


    This is a questions for Google forums, as we're not in charge of the calculated field functions.


    Best,

    Supermetrics team

  • Hi Heidi,


    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 (!)

     

    Regards,

    Giuseppe

Login to post a comment