"means total wages will exceed actual total."

By State, there is no "total" wages. That's because there can be overlap. As you point out, one State might require 100% to be listed, and another has only locally-generated wages being reported. Don't put that total into the Fed fields, and it works fine.