either of Units or Total are not suitable to be directly interpreted as numerics; often times this is because of punctuation. if you are able to use libraries, you might find it convenient to try readr package as its parse_number() function is somewhat more forgiving as to inputs its presented with. Aside from that ... You should explore the contents of your columns to understand what they are.
If you would like assistance consider making a reprex.