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.