Converting NULL to numeric value (0)

[renee35]

Could someone please help me out. I have a report that returns "NULL" if the condition is not met, how do I have it return a "0" instead. I have tried using the Case statement and the convert function, but not sure what I am doing wrong. Thanks for any assistance with this!!

Thanks a bunch!!

-T

 

[thementornetwork]

Hi T,

Instead of displaying the field that could be NULL, replace it by a formula.

IF ISNULL({table.field}) THEN
0
ELSE
{table.field}

 

[renee35]

Thanks a bunch!! Will this work also in SQL?

Thanks a bunch!!

-T

 

[thementornetwork]

I haven't tested it in SQL but it should work as well. At the worst case, syntax may be a bit different (which I doubt) but the concept is the same. Good luck.

EC

 

[renee35]

Thanks!

Thanks a bunch!!

-T