I understand there are differences in how the Totals row data is processed, but this should at least be an option that one can uncheck in the setup of the calculated metric if you don't want it to apply to the totals row. Otherwise it should by default apply.
I keep coming up against this issue, and it's very frustrating that calculated metrics are worthless on the Totals row. I understand that it's a limitation to what the logic is coded to do currently, but aren't things suppose to be coded to produce what Clients need to see in the reports??? Retorical question... I'm obviously just continiously frustrated by this limitation as it seems like such a common sense feature that I'm surprised it continutes to be unavailable.
For example, I'm running a very simple report in SC v.15, Site Metrics > Key Metrics, and only adding two metrics, Visits and the calculated metric Site Conversions (Orders/Visits). I need to see this metric for a rolling seven days, with the granularity set to Day. The report shows the Site Conversion fine on the Day rows, but the Totals row is litterally Summing the Site Conversions column. So at the day granularity level, where I see the conversion rate around 1.7% each day, (give or take), the Totals row shows a Site Conversion of 12.07%... What the %@&#!