Thank you for your forum.
I thought the 'PowerSum' is not a recognized built-in function name, was fixed in SQL Compare V7.1. can you please confirm the exact version of SQL Compare you are using?
With regards to the error, to my knowledge and experience it has not occurred in SQL Compare V10.2.
The latest version is 10.2.3.1 which can be downloaded using this