Calc returning unexpected result

[consultgal]

I have a calculation field defined as:

If( not IsEmpty(x),If( IsValid(x), 1, 0),1)

Field x is defined to be "strcict data type" numeric only.

However, when field x = "15/yr" or "10-15" the calc field is resulting in 1. Shouldn't IsValid return false in that case?

Thanks in advance!

Courtney

[Ender]

Hey Courtney,

Unfortunately, IsValid() only returns false on a local number field if the field contains only text.

Edited August 9, 2006 by Guest

[consultgal]

So what is a good way to test for ANY non-numeric data in a numeric field?

[Ender]

In FM5, I think you'll need to do it like this:

Change the field x to a text field. Then add a calc like this:

tempInvalid_x (calculation, number result) = case(texttonum(x) <> x, 1)

Perform a find on tempInvalid_x = 1

Correct the offending values, then if you wish, change the field type of field x back to a number, with the validation.