Can you share the sumOver that’s giving you an error?
Use case #4 in this article covers percentage of total calculations. Let me know if that helps.