Set expression Issue in count of emp

[kakani87]

Hi Everybody,

displayed sample data app it is showing access details of an employee IN and OUT with Total time spent

Now want to display the count for red colour highlited rows of emp like count of IN time in red it is displayed  properly but like that OUT and Timespent count as well to displayed. EXPRESSION for IN considering as

=Count({<EmpName={"=Min({<tran_date = {$(=Num(Max(tran_date)))}>} SignIn)>$(vSignin)"},tran_date={'$(=maxstring(tran_date))'}>}DISTINCT EmpName)

Kindly help me with this.

Regards,

Kakani.

[Anil_Babu_Samineni · Accepted solution]

PFA

[kakani87]

Anil Thank you for the support.

[kakani87]

Anil Time spent in HRS is showing wrong data.

Here I'm sending you the Attachment Kindly check this TIMESPENT COUNT.

[Anil_Babu_Samineni]

May be this?

=Sum(Aggr(If((Max({<tran_date =  {"$(=Num(Max(tran_date)))"}>} SignOut) - Min({<tran_date =  {"$(=Num(Max(tran_date)))"}>} SignIn))<'08:00:00',1,0), tran_date, EmpName))

[kakani87]

This is Correct Anil.