13 Replies Latest reply: Jul 19, 2018 1:33 AM by Shahzad Ahsan RSS

    Get Employee count who are continuously absent for 10 or more days

    Shahzad Ahsan

      Hi

      I need to count employees who are continuously absent for 10 or more days. Excluding weekends, here weekend days are Fri and Sat

       

      Sample data and qvf is attached. Please update in this qvf .


      This sample data contains total 5 employees out of which 2 are absent continuously for 10 or more days. Those are,1001 and 1004. I want measure expression that count these 2 employee.