4 Replies Latest reply on Oct 17, 2016 12:45 AM by Mazhar Sayed

    Absconding / Continuous Absence / Abscond Report Logic

    Mazhar Sayed

      Hi All,

       

      I want to create a report showing the employees who are continously absent for more than 2 days by today.

       

      I have 3 fields

      1. Employe Id - this is a list of all employee id's

      2. Data Type - here I have 3 fileds: Present, On Leave and Absenr.

      3. Date - This is the date field

       

      And my data is till today -1

      So here I need a list of Emp Id who were absent for today -1, today -2 i.e absent for last 2 or more than 2 days in continuity

       

      Please help me with the logic

      ..............................

      I have attached a sample workbook, I need the count of employees who are absent since 12th of october,

      So emp ids that are showing Absent as data type for the 12th and 13th of October in continuity will fall under 2 days bucket as today is 14th Oct.

      Similarly I need buckets of count of emp 3 to 5 days ...i.e emp that are absent for more than 3 to 5 days in continuity till today.

       

      Thanks