4 Replies Latest reply: Jun 15, 2016 1:16 AM by Rick Worthy RSS

    Employees who only take leave on Monday & Friday

    Rick Worthy

      Hi I am trying to find a way to create a chart that will show Data for employees who take sick leave exclusively on Mondays and Fridays.  (Eventually, I am looking to include each side of Holidays as well).  Originally, I was using the experession

       

      =if(WeekDay(leave)=0 or WeekDay(leave)=4, sum({<[Leave Type]={'Sick Leave'}>}pay_hours), null())

       

      However, this returns the results for people who have leave on those days but may have leave on the other days as well.

       

      Any help you can give would be appreciated!