6 Replies Latest reply: Mar 14, 2012 9:59 AM by Marcin Dworak RSS

    Advanced Search - search in two variables in one formula (OR)

      Hi,

       

      I have a situation where I have to make a search on two variables - I need the data where Var1 values are in list of specific values (so match function I suppose) or Var2 values are in list of some specific values. What I think I need to do but don't know how is to create an advanced search which would do a "search in" for two different dimensions at the same time (for the OR statement).

       

      So far I've tried to apply the advanced filter, used the Var1 in the "search in" and the below as the code (these are dimensions, the values are IDs):

       

      =(Match([Var1],'41','45','39','7000064','7000042') OR Match([Var2],'12','31','32','49','51'))

       

      but this doesn't work correctly. I cannot create any new variables and I don't have one variable on which I could do the "search in". You can assume that all I have is something like a table I've attached (besides the flag variable).

       

      Thanks in advance for your help,

      Marcin

      Var1Var2DataFlag
      2000012-1720
      7000042-1251
      7000062-1570
      7000022-130
      2000015-13450
      7000007-13250
      700002863210
      70000296320
      7000062121541
      7000062311091
      700006212861
      -16630
      -112271
      -1436430
      70000239340
      700006492341
      4596731