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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Remove Decimal 2
- Thread starter bv0719
- Start date
-
2
- #2
CoSpringsGuy
IS-IT--Management
totext({@number1}*100,0,"")
_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection
_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection
- Thread starter
- #3
ImArchimedes
Technical User
- Sep 25, 2007
- 62
Just for a little more insight into how that works, if you are interested, here is the function format:
totext(variable,x,y)
x = The number of decimal places to carry over when converting to text (1=.0 and 5=.00000)
y = Character to be used to separate tens, hundreds, thousands (like the comma in "1,000")
totext(variable,x,y)
x = The number of decimal places to carry over when converting to text (1=.0 and 5=.00000)
y = Character to be used to separate tens, hundreds, thousands (like the comma in "1,000")
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question