Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to change a 0.244 percentage to 2.44% 1
- Thread starter mudflap
- Start date
-
1
- #2
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
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
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
Percentage is (X / Y) * 100. Alternatively, it's just X % Y.
Naith
- Thread starter
- #4
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
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
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
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
- Thread starter
- #6
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
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
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
tek@kenhamady.com
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
tek@kenhamady.com
- Thread starter
- #8
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question