4 Replies Latest reply: Jun 29, 2010 8:20 PM by John Witherspoon RSS

    AGGR vs SET ANALYSIS why do my numbers differ


      I am investigating the use of the AGGR function, but the values returned dont seem to be what i expect

      the following expression




      count({<Month = {'May 2010'}, EmpStatus = {'Active'}>} [Employee NO])


      returns 7895

      I try and do the same with AGGR using



      count(aggr(if(EmpStatus= 'Active', if(Month = ScorecardMonth, [Employee NO])),[Employee NO]))






      But this only gives me 718?


      7895 is the right answer, where i am i going wrong?