Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ....
I want to display the records where there will not be entries
i.e. list of people Absent in a day using biometric access data with flag 0,1 (IN,OUT)
here I'm Attaching a sample
Can any one help me to acheive this
Regards,
Sai.
Yes absolutely
Hi Tresesco ... Any solution for this issue
I will try to spend sometime on it today and let know accordingly.
Okay.
May be like this?
=Max({<tran_date,EmpName=p({<tran_date={'>$(=num(Addmonths(today(),-1))) <$(=num(Today()))'}>})>* <tran_date,EmpName=e({<tran_date={'$(=If(getselectedcount(tran_date),Max(tran_date),today()))'}>})>}tran_date)
When you clear all and see, you might not see any employees, because you don't have data for Dec'17 data (today()- 1 month). You can replace highlighted -1 by -2 to see results for absentees who were at least present in last two months, or try on data where you have data of last months.
Hi Tresesco,
How to display only the EmpNames with last login lesser than the maximum date.
Lets say with out dynamic selection only the people last logged in date less than max date to be displayed to consider them as on date absent.
Here in the above it is displayed the people who logged in on max date as well showing with out filter in tran_date.
Hi Tresesco ... can we display all days of an employee in a month where is not in
lets say for example an employee list of days absent to be displayed this way
EID Emname Dates(Absent in the month)
C000872 Ajith 16-12-2017
C000872 Ajith 20-12-2017
C000872 Ajith 31-12-2017
now he is considered as all three days absent.
if we filter month wise like this