6 Replies Latest reply: Oct 2, 2012 7:21 AM by Jonathan Dienst RSS

    How to select or exclude values based on other fields in set expression?



      I want my expression to have only set expression for speed and memory (use a lot of data...)


      But I can't figger out how to do the following in a set expression, I never get the right answer when my pivot is expanded and collapsed... Any help?


      AVG({$<Field1={1,2,3}, Field2={4}>} if(Field5=Field6,'',Field5))


      I thought something like this:


      AVG({$<Field1={1,2,3}, Field2={4}, Field5-=Field6>} Field5)


      But I tried a lot already...


      Thanks in advance!