Function Index

IsNotNull

Returns True if the argument contains valid data, and False if the argument does not contain valid data (Null).

Usage

IsNotNull(<argument>)

argument (required) Any argument can be provided. The function can analyze one argument at a time. IsNotNull is often applied to a column of data to test for non-Null values.


Examples

IsNotNull([Sales])
  • Function will return True for rows where sales data exists and False for rows where there is no data.