2 Replies Latest reply: Aug 29, 2011 7:01 PM by ianmcgivern RSS

    Set Analysis Query

      Good Day, I have the following expression that I would like to convert to Set Analysis:


      =Sum(If([Field1] = 'Value1',
      IF([Field2] = 'Value2',
      IF( [Field3]>0, [Field4]))))


      What I have so far is this:


      =Sum({$<[Field1] ={'Value1'},
      "=Sum({ $ <[Field2] = {'Value2'}>}
      [Field3]) >0"> }[Field4])


      but it does not give me the desired result.  Anybody know where I'm going wrong?