I have a formula field on an object that displays an image if certain criteria are met:
IF(Anonymous__c , IMAGE("/servlet/servlet.FileDownload?file=015A0000001dCp6", "Anonymous - Do Not Contact or Solicit"), IF(Another_Condition__c, IMAGE("/servlet/servlet.FileDownload?file=015A0000001dCp6", "Etc. - Imagine a cascade of conditions"), null))
I'm trying to filter a report to exclude any record that displays an image in this field. I've tried the usual:
Image Filter not equal to <blank>
But it doesn't work. Is there a way to do this?
Consider splitting the logic out into a separate formula for the text and image versions:
And then filter your report based on