Rounding to Thousands

[mwhager]

I need to round some financial numbers to thousands.

If the number is $3,998,876.00 i need it to display as $3,998.8 - any suggestions would be appreciated.

 

[kenhamady]

Round ( {table.field} / 1000 , 1) 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

 

[kenhamady]

Actually, rounding will give you .9 in that example.
Use Truncate () instead of Round() if you want it to always round down. 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

 

[dgillz]

Use negative arguments with the round function. Examples:

round(1234,-1) returns 1230
round(5,875,679,-3) returns 5,876,000



Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[kenhamady]

That does the rounding, but doesn't move the decimal. 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

 

[dgillz]

My fault, I didn't read beyond the title of this post. Now that I have read it, round({Number},-2)/1000 should do the trick. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com