Trying to change a 0.244 percentage to 2.44% 1

[mudflap]

I have a column of about 30 rates of commision. I am
trying to change the current decimal value from 0.244 or .1111 to 2.440 % and 11.110 percentage.

Is there a way of change that without using a formula on each one of these numbers.

Thanks
Peter

 

[Naith]

Hey Peter,

It sounds like all you want to do is move the decimal place along 1 place for one field, and two places for the other field.

In either case, I think you'd have to use a couple of very simple formulas to the tune of:

{Field}*10

and

{Field}*100

If you want the percentage symbol to appear in the field, press the % button on the right of the Formatting toolbar.

Naith

 

[Naith]

By the way, if you need to make this amendment to the percentage field, you should perhaps consider that the formula you're using to deduce the percentage is probably inaccurate.

Percentage is (X / Y) * 100. Alternatively, it's just X % Y.

Naith

 

[mudflap]

I did this..I took the field it is call Rate.
RIght clicked it format field.
Under the decimal area I choose the forumla option.
Then I put in {rate}*100
Gives me an error saying bad results.
Do I have to do a formula for each rate.
Or is there a way of putting a formula on the whole field.
In this case rate?

Thanks
Peter

 

[Naith]

No Pete, you don't format formulise the decimals. The {Field}*10 example is actually an entire formula. Create a formula with just that line in it, and use that to return your percentage.

Out of interest, are you querying a database field to give you your percentage, or are you using a formula to return the percentage? If it's the latter, post it up and let's see what you got. I think we should be able to set it straight so you don't need to create additional formulas.

Naith

 

[mudflap]

The field is being filled by a database not a forumla..
This should be simple..But I am not getting it.
Do I need to put a forumla on each one of these records?
Can I not put a formula on the whole column. I tried it
but it gave me a bad result error.

Peter

 

[kenhamady]

If these numbers are a single column coming from the database (a field) then you can use one formula to change the entire column.

Write a new formula (insert/formula field or Insert/FieldObject) and write a formula that is:

{your.field} * 100

Then put this new formula in place of the field on the report. Click the percent on the toolbar to format this field with the percent sign. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mudflap]

Great, thats what I needed.
Thanks Ken.
And thanks Naith.