Data Studio: Convert NULL Values to Zero for Calculated Fields

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.