Data Studio: Convert NULL Values to Zero for Calculated Fields

Data Studio May 23, 2021

Occasionally you may experienced that a calculated field returns "No Data" when one of the field is is NULL.

Taking an example here:

I have a blended data source combining Facebook Ads and Google Ads. Of which Facebook data is available only from current month. So I create total amount spent I get the value correct for current month;   but data return "No Data" for previous month as Facebook spend was NULL.

To overcome this, at data studio we can use a function named NARY_MAX

The function will return "0" instead of NULL without breaking the calculated field.


Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.