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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert to number

Status
Not open for further replies.
mart10

mart10

MIS
Nov 2, 2007
394
GB
I am using CR XI

How do I convert 12345 (text) to a number eg 12345.00 which I can then do sumation on in a grouping

thanks
 
Sort by date Sort by votes
tonumber(numericstring)

this will fail if non numeric

You can do

If isnumeric(numericstring) then tonumber(numericstring)
els 0

Ian
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
436
mmck1964
mmck1964
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
284
jchewsmith
jchewsmith
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
252
socalvelo
socalvelo
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
182
socalvelo
socalvelo
Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
365
Brian S
Brian S

Part and Inventory Search

Sponsor

Back
Top