Filter Function - Keep True zeros

Question

I am using a filter function, which is working great for my needs: =FILTER(Table1, Table1[Custom - Question pod group]=A3, ""). However, I am unable to figure out how to keep true zeros (values on my table can be zero) and then have other fields where there is not any data show as blank.

I tried this custom number formatting, but it removes all zeros, even if they are true zeros: 0;-0;; @

I have also adjusted my display settings and have tried checking and unchecking the box in Excel Options> Advanced> Display options for this workbook to:

Checked - Show a zero in cells that have zero value. Result is a 0 in all "blank" fields

Unchecked- show a zero in cells that have zero value. Result is cells with no value and cells with a true zero value are now blank.

Any assistance would be most appreciated!

Answer 1

Try

=LET(f, FILTER(Table1, Table1[Custom - Question pod group]=A3, ""), IF(f="", "", f))