5 Replies Latest reply on May 11, 2018 8:47 AM by Deepak Rai

    Cannot mix aggregate and non-aggregate

    Pooja Gupta

      Hi, I am having the above error

       

      if [Metric] = 'Headcount' and [Week End Date] = [PriorYear HC]

      then ATTR([Employee Count] )

      else

      0 end

       

       

      where PRIORYEAR HC IS

      MAX (if (YEAR([Week End Date])) = YEAR(DATEADD('year',-1,{fixed : MAX([Week End Date])})) THEN ([Week End Date]) END )

       

      Thanks,

      Pooja