Skip to main content Skip to complementary content

IsNull - script and chart function

The IsNull function tests if the value of an expression is NULL and if so, returns -1 (True), otherwise 0 (False).

Syntax:  

IsNull(expr )

Information noteA string with length zero is not considered as a NULL and will cause IsNull to return False.

Return data type: Boolean

Arguments
Argument Description
expr The expression or field containing the data to be measured.
Example: Chart expression
Example Result

IsNull(Productname)

Returns -1 (True) if ProductName is a null value, otherwise 0 (False).

Example - IsNull fundamentals

Example - IsNull scenario

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!