15 Replies Latest reply: Aug 21, 2017 12:10 PM by Sunny Talwar RSS

    More than and less than in a Filter

    kurleigh henry


      I have been trying to put together a set analysis in a filter and got it to work on the basic level. i.e.

      =[Shirt Orders]<=720  or

      =[Shirt Orders]>1000

      and the output in the filter drop down is -1 and 0 that is fine.


      When I add more than or less than the functionality did not work.

      =[Shirt Orders]>1000<=1200

      I also tried

      Count({<[Shirt Orders] = {">$(1000)<=$(1200)"}>} [Shirt Orders])

      but it did not work.

      Any help is appreciated.