Override a NULL in a Formula

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Override a NULL in a Formula

Message

From

26/01/2005 12:20:00

Kevin Goff
Pennsylvania, United States

26/01/2005 10:11:57

Stephen Russell
S. R. & Associates
Memphis, Tennessee, United States

General information

Forum:

ASP.NET

Category:

Reporting

Title:

Re: Override a NULL in a Formula

Miscellaneous

Thread ID:

00980755

Message ID:

00980846

Views:

Hey, Stephen,

I've never run into this, so this is just a wild guess - in the return statement of your function RepairTotal, can you do the ISNULL check there? That way you "shouldn't" ever get back a NULL from the UDF...just a zero if it was null.

(my theory is that ISNULL only works on fields, not formulas)

Let me know if that helps...
Kevin

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Map

View

Click here to load this message in the networking platform