Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had a user ask which Set Analysis formula to use if they wanted Val >=6 and <12. They had tried {<Val={"<12"},Val={">=6"}>} and {<Val={"<12>=6"}>}. I was surprised at the results.
I think Same field in one set is giving unpredictable results, better to use other operators in case needed to use same field in multiple conditions. Below expression gives the intersection set -
Count({<Val={"<12"}>*<Val={">=6"}>}Val)
I agree, the normal interpretation of {<Field1={"<12"},Field2={"<=6"} >}is an "AND" test. It appears that {<Field1={"<12"},Field1={">=6"}>} is unpredictable.