Trying to sum a text field that has been converted to a number 1

[zidol]

I have a text field that I converted to a number. I am not able to get a sum of the new number field. The I have tried the following formulas.

Formula Name: NumPerson1
Formula: ToNumber({IncdApps.NUMBEROFPEOPLE})

I place this formula in the report and the field shows up as a number.
I insert a summary for this new field and get an Error message "The string is a non-numeric".
________________________________________________________________________________________________________________________
Then I tried another formula;
Formula Name: NumPerson2
Formula: Sum(ToNumber({IncdApps.NUMBEROFPEOPLE})) and get an Error message "A field is required here"
__________________________________________________________________________________________________________________________
Then I tried another formula;
Formula Name: NumPerson3
Formula: sum({@NumPerson1}) - it brings me back to the NumPeron1 formula and error message "The string is a non-numeric".

I would appreciate any help!

 

[AndyMc]

I usually have better luck using the val() function rather than ToNumber()

 

[zidol]

That worked! Thanks so much!

 

[BettyJ]

Do you have null values in the text field?

 

[zidol]

No I do not have null values.