I’m running paid media for my client and I have a sheet with daily performance linked as a resource. The metrics are numbers and should cleanly add/multiply/subtract but the numbers in the screenshot below are just incorrect. I blended the ad platforms and sheet together. Screenshot below there as well. the revenue metric is the data summed and the orders metrics is the count of revenue data so simulate orders. The math just isnt mathing… please help!
There is no date range in your left table (the Google Sheets one), hence taking all orders when dividing. Put date in your date range, and it should be fine.