I've created an expression in a filter pane. I did this because I wanted to use fields from across tables and this worked better than joining all tables and filtering via script since I have other sheets this isn't needed for and has caused other issues for.
I also have a count KPI on a record id field. I can see the expression (see below) works when I select either Y or N as the record id counts change. However, when I filter to only N and export I still get all records. I don't understand why and if there is a fix.
here's the expression I created:
=if([Origin Type]='ACQ-DELETE' and isnull([Number Of Gifts]),'Y','N')
