3 Replies Latest reply on Dec 3, 2018 8:08 PM by Greg Davey

    Interactive filter with conditions

    Greg Davey

      Hi all

       

      I have an interactive filter on a string field that contains the Australian financial year,  yyyy/yyyy eg, 2017/2018, 2018/2019 etc.  I want the user to select a single Australian financial year, and the data displayed be all records that satisfy one of the following:

      • Financial year selected
      • All prior financial years to the financial year selected
      • All nulls

      I’d appreciate assistance with achieving this.

       

      Greg