Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sqlscript: How can to check for nan?

Hello community,

I'm executing a PAL forecast procedure (AFL) which gives a result table. Depending on the input data, the PAL forecast algorithm fails leading to -nan in the result table.

How can I check the result table for -nan? It dumps if I do a simple select:

Could not execute 'SELECT * FROM PAL_FORECASTSLR_RESULT_TBL' in 3 ms 300 ┬Ás .

[314]: numeric overflow: the value -nan cannot be acceptable

The source code to reproduce the error is attached!



Former Member
Not what you were looking for? View more on this topic or Ask a question