text field format

[2001 JI Open Discussion]

By: tim - timinsaudi

text field format

2004-05-03 18:08

I wish to format a text field as a percentage.

 

I have set the pattern to have 2 decimal points but I also wish to display the % sign.

 

Is this possible?

[dianaj59]

I have this problem as well. 

For instance if I want the report to show 33%, how can I use the text field property pattern box to do this?

If I leave the % in, it reflects as 3300%; if I take it out and leave the box blank, it shows as 33.

I want it to be 33%.  Is this possible?  I think there must be a better way than to leave it 33 and add a text box with a % symbol in it.

Thanks.

[svenn]

I guess the idea is you will be showing the percentage based on a field value of #.##. Of course as you have noticed this is not always the case. To get around this I take the whole value that I'm displaying and divide it by 100. The % formatter then converts it to the right value.