Multiple Select in Field criteria (Range + Single Value)

[#1]

Hi,

I am currently putting together a document where the user needs to be able to select a range of dates and then be able to toggle on a seperate value to be included. The range selection works fine using triggers for Min/Max vars but when I try include an extra single value I am unsure how to make it filter properly.

Field = Expiration Year

Range Select in Field example: >=2013<=2015

The data also includes the value 'MTM' so I need to be able to include that in the dataset based on toggling a button.

Can I modify the filter string to include this value AND the range? I have tried varius combinations but can't figure it out. Or can I make the trigger put the values as 2013,2014,2015,MTM instead of the range example above?

Thanks in advance

[#2 · Accepted solution]

I figured it out.

This worked: =if(MTM=1,'(') & '>=' & minExpYr & '<=' & maxExpYr & if(MTM=1, '| MTM)')

(MTM being the button varible to toggle on/off)

Final Select in field criteria shows as: Expiration Year: (>=2013<=2015| MTM)

The brackets were the issue, I was not including them.