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?

      Hi,

       

      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!

       

      Regards,

       

      Bram