Percent calculation w/o % sign

[AnnPhil]

How do I get the % sign NOT to print when I have a calculated field, which is formatted as a percent?
For example, I have a column header that says Percent and I have numbers in rows which print as 56% but I want to print 56, 10% should print out as 10.

Any suggestions?

 

[Tiro Cupidus]

Make the field a regular number instead of a percent. Does it need to be a percent field for any reason?

 

[AnnPhil]

When i format it as a standard number it prints out as 0.56, percent prints out 56% i just want it to print 56. The column header lets the reader know it is a percent. Any other suggestions? Thanks

 

[Tiro Cupidus]

If you run a query to match all the fields in your table you can multiply the percent column by 100.

 

[Krysti]

In your calculation to get the percentage, multiply it by 100. Then format the field as 'fixed' with the number of decimals you want.

 

[AnnPhil]

Thanks everyone that worked!

 

[AnnPhil]

One more question, what is the easiest way to round up in my situation? For example .716 percent print out 71 and i need it to print out 72? Thanks in advance for your help

 

[Krysti]

Do you have the text box in the report formatted as 'Fixed' with '0' Decimal Places?

Krysti

 

[ddmcn]

You can use the ROUND function to round up those numbers

=ROUND([yourfield]*100)

That should take care of it.

Dennis