Quick question about output on a Report

[jerbear29]

Hi all,
Quick question. On a report that I am running, at the end of the report, I have a conversion rate field that totals some of the other fields. Basically it reads something like [Interims] + [Completed] + [Finalized]. To make the report nice and neat, I wanted to make the output appear as a percentage. So I did, Interims] + [Completed] + [Finalized] * 100 & "%". It is giving me a percentage, but the percentage is 59.57104557640%. How do i shorten this output to say 59.57%? Any idea?

thanks in advance,
jeremy

 

[Matt Brown]

re:

Hi,

This may help you,

Right click on the text box to bring the properties up.
Check out the "Decimal Places" property.
If on "Auto" select to "2" or "3" decimal places.

 

[jerbear29]

oops...

oops...when i deleted the first attempt at this formula, i forgot to change the "format" back to percentage. Thanks.