Report filter to remove "DELETED" category

RiKi

240226 SS Vendor's list Report filter2.png

Uploaded Feb 26, 202420.41 KB

240226 SS Report Cost Code DELETED category.png

Uploaded Feb 26, 20244.79 KB

240226 SS Vendor's list Report filter.png

Uploaded Feb 26, 202422.94 KB

Hi All, 

I am trying to generate a report based on the cost codes. One of the categories includes the DELETED version – meaning, the box was originally ticked to be included in a directory, however, amended to be removed. This category then is moved under deleted. Is there a way to remove the "DELETED" list from the report? I tried setting in the filter the following attached but it is still showing.

AravindGP

Hi @RiKi

Looking at your SS Report Cost Code DELETED, the filter will need to look at the Cost Code column. Is DELETED a value in the cell under the Cost Code Column or is there a NULL/Blank value? Depending on the value, you can apply the filter on the Cost Code column.

When you do grouping, the grouping parameter is shown in the primary column, but the value is not stored there. So, there's no need to add a filter on your primary column in this instance

RiKi

The word DELETED is a formula where the word is automatically generated once the conditions are met.