HI,
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))
Then the count of people who left in Sep.
(Count({<NLE_Year={'$(vCurrentYear)'},NLE_Month={'Sep'}>} EmployeeDirectory.ID))
You can see both of these in the attach file. Any help is greatly appreciated.
Thank you and regards,
OnePuttGirl
