Hide rows based on their value

building reports
1

I have cases that I am tracking for each business in my portfolio.

Name of Business, Status (Open or Closed), Date Case Opened, Date Case Closed, Number of Cases, Number of Open Cases

I have conditional formatting for the Number of Cases column (If the Number of Cases is greater than 1 and Status is open then color the cell red).

I want to have the report dynamically hide all rows that do not meet the conditional formatting.

I have created a column that I am calling Hide Rows with a formula (If Number of Cases is greater than 1 and Status equals Open than show Display otherwise show Hide.

I am then applying a filter to hide all rows that show Hide.

The filter is hiding 90 percent of the rows showing Hide but not all of them.

I am stumped as to why the filter would not hide all rows showing Hide.

Any ideas on what I am missing?

2

I’ve seen similiar things like this that are caused by unexpected differences in the data. Without seeing your actual data, I would guess that something in the data that you are using for the filter (Status or Number of Cases) is either a null value or an empty string which the Hide forumual can’t evaluate.