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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display in thousands

Status
Not open for further replies.
SUCH

SUCH

IS-IT--Management
Aug 18, 2002
3
AE
How do I display the result of a formula in thousands. For example 345,666 should display as 346 and 345,222 should display as 345
 
Sort by date Sort by votes
round({YourField}/1000,0) should do the trick Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

G
  • Locked
  • Question
Multiple groups in same level
Replies
0
Views
164
george1610
G
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
577
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
490
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
872
hilfy
hilfy
D
  • Locked
  • Question
Open a report into Design mode
Replies
0
Views
212
drb1980
D

Part and Inventory Search

Sponsor

Back
Top