kcjstarling
asked on
crystal reports number to 1000 place
How do I format a number field so that it only go to the 1000 place? Example 1,000,500 would be 1,001. I am using Crystal XI
ASKER
There is not a formating option to do this? I do not want to create a formual for every number field on the report?
Had never looked.
Right click the field
CLick FORMAT FIELD
Choose the NUMBER TAB
Choose CUSTOMIZE
Set Decimals to 1
Set rounding to 1000
You can format many fields at once
Just select them all then right click one of them
The same format is available under
FILE --> OPTIONS --> FIELDS Tab
That may only affect new fields and new reports.
mlmcc
Right click the field
CLick FORMAT FIELD
Choose the NUMBER TAB
Choose CUSTOMIZE
Set Decimals to 1
Set rounding to 1000
You can format many fields at once
Just select them all then right click one of them
The same format is available under
FILE --> OPTIONS --> FIELDS Tab
That may only affect new fields and new reports.
mlmcc
ASKER
I had already done the above, the rounding does not drop the zeros so you end you with 1,001,000 instead of 1,001
The only way will be with a formula.
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(({YourField} + 500) \ 1000) * 1000
mlmcc