3 Replies Latest reply on Aug 18, 2016 5:19 AM by Matthias Goossens

    How to filter on a specific data point?

    Christian Vorbeck

      Hi,

      I am trying to filter on a single variable, but can't figure out the right IF statement. In the picture below, I would like the filter to exclude 'Description' 'B' under 30, but for the other 'Descriptions' I would like to include both over and under 30. Something like IF [Description]= 'B' then [OverUnder 30 Days]='>30', but this doesn't work. Thanks.