How to make the "%" sign display?

[RiverGuy]

For the life of me, I cannot figure out how to make a % sign to display on my percentage feilds. My fields are formula fields using "number % number2", but I would like them to literally have the % sign in the display.

Thanks.

 

[Riteshm]

Do not put the formula directly on the reportinstead have another formula as @aaWithPercentage =
ToText ({@aa}) + "%'" (Say @@aa calculates the percentage)

I hope this helps.

 

[RiverGuy]

Thank you sir.

 

[rhinok]

Since the percentage formula ((number1/number2)*100) is numeric, you can use it on the report. Just highlight the field and click the <%> button on your toolbar.

 

[chelseatech]

I'd recommend RhioK's approach. If you use the % button on the toolbar on a numeric field, the percent displays fine.

What the Percent button does is set the &quot;Currency&quot; format on the number: it uses &quot;%&quot; instead of &quot;$&quot; and positions it on the right instead of left. You can sue currency to display other units like &quot;ft&quot;, &quot;hrs&quot;, etc.

Converting to a string with Totext is okay for displaying, but it means you can't use the number in other calculations, sorts, groups, etc.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[RiverGuy]

OK. I think I will use rhinok's method. What I had ended up doing was in my forumla fields, put & &quot;%&quot; on the end of the formula, which works OK, because I'm not sorting by %, but I had to redo my summary fields. Before they were like a weighted percentage, but then I had to go back and redo them to divide the other summary fields to get what I needed.