Convert to Percentage 2

[tdong]

Hi
I am using CR 9 and MS SQL in the database there is a interest_rate field which contain a float number how do I display it as percentage ? example 0.03 which should display as 3% just use CR for 2 days.

I am using it with VB6 in vb 6 report it allow you to format your selection at design time can't format to percentage at all with this CR 9.

 

[bdreed35]

If 0.03 is considered 3%, you will need to create a formula to mulitply it by 100:

{table.field} * 100 & "%"

Or if you need it to be a numeric field:

{table.field} * 100

then click the "%" sign on the Formatting toolbar once you have added the field to your report. This will add the percent in the display of the field.

~Brian

 

[kchaudhry]

You can create a formula like this:

@conversion

{table.interest_rate} * 100

Put this formula in the desired location. Now click on this formula in design view and select the "$" from the toolbar.

Hope this helps!

Kchaudhry

 

[tdong]

Thanks alot now I just know how the formula fields work