The String is non-numeric

[Hillary]

I get the String is non-numeric error message when I try to run the following formula...

If {PART3.ID} like "" then ToNumber(0.00) else ToNumber({PART3.ID})

I have a similar formula in my report that works okay...

If {PART.ID} like "" then ToNumber(0.00) else ToNumber({PART.ID})

The table Part and Part3 is the same, it was just brought into the database a coulple of times.

If there is a value in the table that is non-numeric, how do I find the record? There are 24,000+ part records on this table and becuse this is a User Defined field in a purchased database (Visual) I can't set the Data Type. We are running on ORACLE 8i if that helps.

Thanks!
Hillary

 

[Naith]

It thinks Part3.ID is a number field, or there is an alpha string in the field somewhere in the database. Check the datatype of the field to verify whether or not it's a string or number.

If it is a number field, you'll have to change your formula to:

If IsNull({Part3.ID})
Then 0
Else {Part3.ID}

If it's a string field, then to find the alpha string in the field, create a formula (in a new report, if you like):

Mid({Part3.ID},1,1)

Group by that formula, and place {Part3.ID} in the details section. You can use the Group Tree to pinpoint the record(s) that are not included in the 0-9 groups.

Naith

 

[mbarron]

The following will check for a blank field, if the field is blank, it will display 0. If it is not blank, it will then check it see if what is in the cell is a number. If it is a number, it will return that value. If it is not a number it will return 9999999.99


If {PART3.ID} = "" then 0 else
if isnumeric({PART3.ID}) then ToNumber({PART3.ID}) else
999999.99

Mike

Before: After