Here’s a quick one for anyone using Google Data Studio. When blending multiple data sources to calculate and display a total value (e.g. total conversions) the output will display “null” if one value returns zero.
To fix this, use the NARY_MAX function to return the maximum value of the input arguments.
https://support.google.com/datastudio/answer/7583429?hl=en#zippy=%2Cin-this-article