Convert String Field results to a number?

[pokerace]

I am pulling results from a string field but they are all numbers and I want to sum them. Since I can't sum the results from a string field, is there a way to convert these results to a number field first?

 

[TheBlondOne]

Hi there,

You can try the following formula

If Not isNull({StringField}) Then
If isNumeric({StringField}) Then ToNumber({StringField})
Else 0


Let me know if you get a problem

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[TheBlondOne]

You can also try this as well but this one will only work if the field only contains numbers.

ToNumber({StringField})

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[pokerace]

Perfect. Thanks for the help!

 

[pokerace]

Both solutions worked, actually. Thanks again.

 

[pokerace]

The formula field now gives me the converted Number but when I try to sum the converted field in the report footer the total is much much higher then it should. Any idea why?

 

[pokerace]

Never mind.

 

[TheBlondOne]

did you figure this one out DPK99?

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )