The string is non-numeric error message

[Former Member]

Hi All,

I'm getting the following error message whenever I try to refresh my report and scroll to the next page to view the report data.

"The string is non-numeric"

The formula is as below:

If

    (IsNull ({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS})) Then 0

   Else

ToNumber({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS})

I get the error on the "ToNumber({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS})" part of the formula.

Please note that the field "PRODUCTIVITY_LOG.PRODUCTIVE_HOURS" is of the datatype nvarchar(100) in a SQL Server database.

Any ideas on how to avoid this will be much appreciated.

[abhilash_kumar · Accepted solution]

Hi Nimish,

Modify the formula to:

If (IsNull ({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS})) Then 0

     Else if isnumeric({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS}) Then

     ToNumber({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS})

     Else 0

-Abhilash

[Former Member · Accepted solution]

Thanks!