Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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)