fbpx
Select Page

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

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.

See Also

IsNull

More About Logical Functions

Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.