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

    AGGR vs SET ANALYSIS why do my numbers differ

      Hi,

      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?