1 Reply Latest reply: Jun 30, 2017 12:48 PM by anand varadhan RSS

    Filter pane expression works, but not on export

    Brian Head

      Hi all,


      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')


      Thank you,