Page 1 of 1

Integer to percentage...

Posted: Tue Jan 17, 2006 3:37 pm
by 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____

=> RE: Integer to percentage...

Posted: Tue Jan 17, 2006 4:04 pm
by 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__

==> RE: Integer to percentage...

Posted: Tue Jan 17, 2006 6:16 pm
by Emetsky_(Guest)
Thanks Kathleen! That did the trick.

==> RE: Integer to percentage...

Posted: Tue Jan 17, 2006 7:01 pm
by 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__

===> RE: Integer to percentage...

Posted: Wed Jan 18, 2006 4:28 pm
by kfleming
You may need to format the field to show 2 decimals to have it export the full decimal value.____Kathleen__R&R Support