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
Function will return "0" instead NULL without breaking the calculated field.