String to number

[nigelot]

Hi
Iam trying to create a formula field that changes a string field to a number field (so I can use 'sum'in 'Type of summary' in a running total field.

The string field is called Sqm and only contains numbers ie 1000-

thanks

Nigel
(I have searched but can't find anything)

 

[dgillz]

ToNumber() or Val(). Either should work nicely. Val() has additional functionality that is very nice, read the help files for details. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[IdoMillet]

Have a look at CDbl() or CCur()

Cheers,
- Ido ixm7@psu.edu

 

[nigelot]

thanks for your prompt help

works a treat

Nigel

 

[mbarron]

Create the formula

tonumber(Sqm)

If there is a possiblity the the field may not contian a number use the following to check the field:

if isnumeric(Sqm) then
tonumber(Sqm)

Mike