3 Replies Latest reply: May 13, 2016 7:07 AM by Gysbert Wassenaar RSS

    Filter by Ranges

      Hi All,


      I'd like to create a filter pane so I can break up my data by population size (peak tourism + resident population). I have tried using a pick(match) function to set the ranges but my formula isn't working and I'm a bit stuck. Any help would be appreciated.



      (match(([Peak Tourist Pop]+[residentAndCommunalPop2016]),>'0'and<='100',>'100'and<='1000',>'1000'and<='10000'))





      Thank you