4 Replies Latest reply on Jun 16, 2016 1:34 PM by Tejal Narkar

    Calculating last years(n-1) Headcount

    Tejal Narkar

      Hi Guys,

       

      I am trying to get a headcount of total people working last year. I want it to be dynamic and so I am trying to replace 2015 with MAX(YEAR([Year]))-1.

      COUNTD(IF YEAR([Year])=2015 THEN ([Employee_Perner]) END)

       

      I am getting below errors on doing so:

      Cannot mix aggregate and non aggregate arguments with this function

      Cannot mix aggregate and non aggregate comparisions or reuslts in IF expression

       

      I am new with tableau and I would really appreciate your help.

       

      Regards,

      Tejal