3 Replies Latest reply: Nov 1, 2017 9:39 AM by Sunny Talwar RSS

    Ignore Calculated Filter in Set Analysis

    Mark Ritter

      I have the following expression as a filter:


      =if(num([TerminationDate.autoCalendar.Year])> $(V5YearAgo),[TerminationDate.autoCalendar.Year])


      I want to limit the choices to just the last 5 years.


      Now in other expressions I want to ignore this choice when it is made.  But since it is calculated I can't reference it in the Set Analysis by just the field name,TerminationDate.autoCalendar.Year like I can with other filters that are just a field.


      So how can I add this filter to my list of filters that I want to ignore in my Set Analysis?