I am attaching an Employee Hiring.qvw and there is an Monthly Turnover straight table object where I need an expression that makes this table work. I want the count to include all the employees that have a Date of Hire 'DOH_Date' <= to the CalendarMonthAndYear date and the No longer here 'NLE_Month <= to the CalendarMonthAndYear as well . I used the Master Calendar function from another post and I really don't know if I can use it the way I am trying. Once I get the above working then I divide in the count of the employees who ended in that month of Sep which is 4.
if (([CalendarMonthName])='Sep',Count ({<CalendarMonthAndYear = {"$(<=Date(MonthEnd(Date#(DOH_MonthName, 'MMM YYYY')),'MMM YYYY'))"},CalendarMonthAndYear = {"$(<=Date(MonthEnd(Date#(NLE_MonthName, 'MMM YYYY')),'MMM YYYY'))"}>} Total <CalendarMonthName> EmployeeDirectory.ID))
