BI-RTF numbers with negative sign do not line up correctly
I am pretty new to BI-RTF development and I have encountered a problem that must have a simple solution, but I have not found it yet. I have a basic customer statement report that lists payments and charges by/to the customer and some of these amounts are negative with a negative sign to the right of them. While I have defined all of my fields in a table, the numbers with the negative signs are not not lining up correctly, but are lined up like below, which can certainly not be correct:
1,800.00
8,600.00-
948.00
The number with the negative is not lining up correctly. I have tried to use the straight text from the XML file (by defining the field as text) and I have also defined the field as a number with the appropriate format code. The results are the same. Any idea what I am doing wrong and how I can fix this? This certainly cannot be the expected behavior. Thanks very much for any help you could give me.