Filter Active and Null Values of Assignment Status in Position FTE OTBI Report

Summary:

Filter only Active and Null Values of Assignment Status in Position FTE

Content (required):

We are trying to filter only Active and Null Values of Assignment Status in Position FTE. We do not want to show the row which has "Inactive" assignment status.

If we add filter condition to remove rows with assignment status = "Inactive", the row with NULL value is also filtered out. We also tried to forcibly default the value "Active" for the row where the assignment status is NULL, but it did not work.

IFNULL("Worker Assignment Details"."Assignment Status Type","Active")

Is there a way to display only rows with Assisgnemt Status Type = Active OR Null?