P2P Lending / NFT Lending Forum

P2P Analysis/Investment Sites => Peer Lending Server => Topic started by: Mouser on September 19, 2016, 11:00:00 PM

Title: Finding Null Values
Post by: Mouser on 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
Title: Finding Null Values
Post by: sociallender on September 20, 2016, 11:00:00 PM
Close, but NAs are used for missing values.  Here is the code:

is.na(mthsSinceLastDelinq)

HTH, SL
Title: Finding Null Values
Post by: TravelingPennies on September 20, 2016, 11:00:00 PM
Wonderful, that did it!
Appreciate the ongoing support.  Love the tool.