I want to set Not Null entries as yes and null entries as no for filter

[MikeHerb]

I have this column named "Deleted" which is when it was deleted:

but rather than having random dates and times I want to set Null as No and Not Null as Yes.

How do I go about this?

[Vegar · Accepted solution]

You could do this with an IF() statement. 

If([Deleted]='NULL', 'No', 'Yes')

[MikeHerb]

@Vegar Thank you so much! that worked perfectly!! I was making the expression way too complicated! hahah