1 Reply Latest reply: Mar 15, 2012 1:48 PM by Stefan Wühl RSS

    Problem with exclude in Set

    Göran Hofstedt

      Hi

      Can anyone se why the exclude FR don´t work in this set?

       

      =Count({$<Insats.SCBKOD={">=13<18"}>}{<Insats.INSATSGRP1-={'FR'}>}{<Insats_Inledd={$(=Chr(39)&Concat(Distinct Datum ,Chr(39) & ',' & Chr(39)) & Chr(39))}>} DISTINCT INSATSID)

       

      It´s just like it overrule it becuase it presents the same as with out...

       

      /THanks!

        • Problem with exclude in Set
          Stefan Wühl

          Each {<...>} is defining a set. I don't believe that you can use set analysis with three sets like above, I think only the last set will actually be used.

           

          Why not use one set with a set modifier with all three fields:

          =Count({$<Insats.SCBKOD={">=13<18"}, Insats.INSATSGRP1-={'FR'}, Insats_Inledd={$(=Chr(39)&Concat(Distinct Datum ,Chr(39) & ',' & Chr(39)) & Chr(39))}>} DISTINCT INSATSID)