6 Replies Latest reply on Feb 5, 2018 5:59 PM by Robert Reid

    Anyway to create formula in filter that will accept multiple params

    Robert Reid

      I have a table has a column PERIOD_TYPE with values Weekly, Monthly, Yearly

       

      I am trying to create a filter that operates similar to the follwing 'incorrect' code:

      Case [PERIOD_TYPE]

      When "Weekly" Then "Weekly"

      When "Monthly" Then ("Weekly" or "Monthly")

      When "Yearly" Then ("Weely" or "Monthly" or "Yearly")

      End

       

      Placing [PERIOD_TYPE] = "Weekly" in the fitler formula box works, but I need a way to return values in the table that meet more that one value.

      That is, acting like a multi-select parameter (but via formula).

       

      Thanks in advance.