trouble with values

[jhomer]

Hope this makes sense:

I have a satisfaction survey posted online using IWP. The values are stored as text values 1-9 and also N/A for non applicable.

In another table I use these values to calculate averages and the like for reports to be used by various personnel. In order to use these values in the calc. I use corresponding fields for each of the values that use a getasnumber function to take the values and change them to numbers. Most of calculations use the avg function provided by FM. This ignores values that were marked as N/A in the original table(this is a good thing).

Heres the problem

I also have an Low Score Indicator field that evaluates the numbered values and marks any record with a value of 3 or less as an Unsatisfactory Result. However this calculation views anything with an N/A as a bad marking and marks the record unsatisfactory.

Ive tried to change the calculation in the indicator field to only evaluate marks that are greater then 0 and less then 4 but this still gives me the return

[sbg2]

If(GetAsNumber(Text) > 0 and GetAsNumber(Text) < 4; "Unsatisfactory results")

When I use the above calculation only the numbers 1, 2 and 3 are flagged as "Unsatisfactory results".