I cannot use Is Null in a record selection expert. I use the same wording in excel and SQL QA with no issues.
I need all records that are not '5 - Project' including Nulls. Once I put the criteria of '5 - Project' it excludes the null records.
{@dtCompleted} = {?Completed_Date_ Range} and
{TASKS.TYPE} = "Information Technology" and
{TASKS.PRIORITY} <>'5 - Project'
This does not give me the nulls for the Priority field.
The one I use in QA or in Excel is
{@dtCompleted} = {?Completed_Date_ Range} and
{TASKS.TYPE} = "Information Technology" and
({TASKS.PRIORITY} <>'5 - Project' or {TASKS.PRIORITY} is null)
This gives me the "The ) is missing" error. Help!