You are getting this because the data within the THEN portion of the CASE statement is a number. You would need to put a numeric value into the ELSE portion. Your other option would be to leave the THEN value as a text string.
A single column can only have a single data type. “convert(numeric, ‘-10.00%’)” is a number, while ‘Not Numeric’ is a string.