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 is null
PLS Version 7.904
Any suggestions appreciated.