What am I doing wrong?!?! - Basic blending not working

[superfoam]

Scratching my head on this one as I’ve done this exact setup in the past and it worked fine.

Goal: Showing Total Ad Spend in a card (FB amount spent + Google ads Cost).
Data Source: Supermetrics FB Ads & Google Ads connectors

Key Field: Date

Metrics: FB - Amount Spent | Google Ads - Cost

Joining type: Left Outer

Using a calculated field in the card Amount Spent + Cost, aggregation is Sum. Getting “No Data” as the result. The individual data sources work fine. I can see FB spend & Google spend using single data sources. What am I doing wrong?!?!

[Looker_Studio_B]

Try this : How to display Facebook Ads and Google Ads metrics in the same table in Looker Studio? | Medium

But as you seem to be missing data on a given date, your SUM should be: SUM(IFNULL(Google Cost,0)+IFNULL(Facebook Cost,0))

[superfoam]

OMG That works! Thank you so much. I was trying narymax function which didn’t solve the issue where 1 platform has $0 ad spend in a given time period! Thank you so much!

[Looker_Studio_B]

Glad to read so