I’m getting the same as you, it would seem like table calculations do not support summation of totals in that way.
Insights is based on Google Looker.
I’ve found these articles:
Using table calculations | Looker | Google Cloud
Display potentially confusing table calculation totals as nulls | Looker | Google Cloud

Why don’t my totals match the values in my table? | Looker | Google Cloud

