Skip to main content

Author Topic: Finding Null Values

M
  • Posts: 1
Finding Null Values
OP: September 19, 2016, 11:00:00 PM
Having difficulty filtering on NULL values.  Inputting any numerical value in the “Months Since Last Delinquency” range fields excludes all returns without a value so trying to create a custom query.   

I know the language is not quite SQL but I cannot find the right syntax to make the query work.  I am attempting to filter only loans with a null value in the field mthsSinceLastDelinq. 

Tried several variations in the "Custom Filter - Experts Only" field including:
   mthsSinceLastDelinq isnull
   mthsSinceLastDelinq is null

PLS Version 7.904

Any suggestions appreciated.

Thanks, Mouser
  • IP logged

s
  • Posts: 27
Finding Null Values
#1: September 20, 2016, 11:00:00 PM
Close, but NAs are used for missing values.  Here is the code:

is.na(mthsSinceLastDelinq)

HTH, SL
  • IP logged

T
  • *****
  • Hero Member
  • Posts: 6586
Finding Null Values
#2: September 20, 2016, 11:00:00 PM
Wonderful, that did it!
Appreciate the ongoing support.  Love the tool.
  • IP logged