Crystal Reports Error - The String is non-numeric 1

[cyreports]

I am getting the following error:

"The string is non-numeric"

from this formula:

IF ToNumber({aaUDS7;1.ObsValue}) < 7 and ToNumber({aaUDS7;1.ObsValue}) > 0 then
1
else
0

It specifically highlights this section: ToNumber({aaUDS7;1.ObsValue})

 

[Turkbear]

Hi,
That error indicates that at least 1 value in that field is not numeric - often that is because of a NULL value, try:

If Not IsNull({aaUDS7;1.ObsValue})
Then
IF (
ToNumber({aaUDS7;1.ObsValue}) < 7 and ToNumber({aaUDS7;1.ObsValue}) > 0
) 
then
1
else
0

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cyreports]

I am getting back the same error message with this change.

 

[lbass]

Try:

If Not IsNull({aaUDS7;1.ObsValue}) and
isnumeric({aaUDS7;1.ObsValue}) Then
IF (
ToNumber({aaUDS7;1.ObsValue}) < 7 and ToNumber({aaUDS7;1.ObsValue}) > 0
) then
1 else
0

-LB

 

[cyreports]

Thanks!