3 Replies Latest reply: Mar 30, 2018 3:46 AM by Nizam HM RSS

    Count with a date filter applied

    Patricia Thomas

      I'm trying to do the below formula with a date filter of 12/01/2017. Any assistance appreciated.

       

      count([2])*2+count([3])*3+count([4])*4+count([5])*5+count([6])*6+count([7])*7+count([8])*8+count([9])*9+count([10])*10)/(Count([Employee_ID])