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,

      brian