MicroStrategy ONE
IsNotNull
Returns TRUE if value input is not NULL; otherwise, returns FALSE. This is a comparison function.
Depending on your MicroStrategy product and licensing, this function may not be available.
Syntax
Where:
Argument is a fact or metric.
Usage Notes
The IsNull and IsNotNull functions work only with the data returned from the database. For example, if the database data is NULL, the IsNotNull function returns a FALSE. However, you may see NULL data when you manipulate a report after its original generation and that manipulation does not regenerate the data from the database. This can happen when you page by, for example, and the result includes a NULL.