Thanks for the reply.
Space is definitely the problem here. I actually want to display those that are greater than or equal to 1000% as text ">1000%", while those that are smaller than 1000% stay being shown at their actual values. Is there a way to do that?
You could create a calculated field which is like IF([YOURNUMBER]) >= "1000%" THEN ">1000%" END
If you haven't a string, you can go like that: IF(SUM([YOURNUMBER]) >= 1000 THEN ">1000%" END