> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# IsNotNull

> Use the Sigma IsNotNull function to return True if the argument does not contain missing data values, and False if the argument is Null (i.e..

The **IsNotNull** function returns True if the argument does not contain missing data values, and False if the argument is Null (i.e., contains missing data values). This function is often applied to a column of data to test for non-Null values.

## Syntax

```
IsNotNull(argument)
```

Function arguments:

* **argument** (required) The value, column, or parameter to be evaluated.

The function can analyze one argument at a time.

The function does not work with Multi-Select List and Switch type parameters. To check if a Multi-Select List parameter isn't empty, see [ArrayLength](/docs/arraylength).

## Example

```
IsNotNull([Sales])
```

* Returns True for rows where sales data exists and False for rows where there is no data.

```
IsNotNull([prm-date-range].start) and IsNotNull([prm-date-range].end)
```

* Returns True when a start and end date is provided in a Date Range parameter.

```
IsNotNull([prm-text-box])
```

* Returns True when no value is provided in a text box parameter.

## Related resources

* [IsNull](/docs/isnull)