I know there is an article on how and why total (sum) of calcualted metric makes no sense.
However, there are cases, where total of calcualted metrics makes sense.
There should be an option in the calculated metric creation dialog to have an option to enable totaling of calculated metric.
This avoids offline report preparation using Excel!