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 truncate

Status
Not open for further replies.

arvindanikode

IS-IT--Management
Dec 5, 2002
1
US
Using crystal reports,

Local StringVar txtS := "1020.0020";
totext(truncate(tonumber(txtS),4),4);

This will give me "1020.0019", whereas I would like to display "1020.0020" only. If I just use:
truncate(tonumber(txtS),4), this gives me "1020.00"

Can anybody help !!
 
Why go through these hoops?
You already have the result you are looking for.

However the following formula works:

local stringvar txt:="1020.0020";
totext(tonumber(txt),4) Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top