Integer to percentage...

[Emetsky_(Guest)]

Hi Kathleen! ^need your help.____I have a 2 digit integer input field on the Data-Entry Screen.____Users would input 10 or 3 with no decimal points.____But on the Report, I would like to transform the 10 or 3 into a .10 or .3 ____I^m not talking about merely formatting the integer field as a percentage.____Is this possible? ____TIA,__Emetsky____

[kfleming]

You could create a calc field that is datafield/100 and then format that field to display as a percent.______Kathleen__R&R Support__

[Emetsky_(Guest)]

Thanks Kathleen! That did the trick.

[Emetsky_(Guest)]

>You could create a calc field that is datafield/100 and then __>format that field to display as a percent. __>__>__>Kathleen __>R&R Support ____Hi Kathleen,____Your solution works fine on a regular report, even when I create a PDF.____The problem is when I export to a DBF flat file. The calc field shows up with zeros.____Please help!__Emetsky__

[kfleming]

You may need to format the field to show 2 decimals to have it export the full decimal value.____Kathleen__R&R Support