Count of Not present Emp in current Month.

[lalitkgehlot89]

Hi,

In provide sample data I want to check the count of Emp who was not present in last month but not in current Month.

In given date Empcode -3 is not in Mar18,

[lalitkgehlot89]

Thanks a lot Tresesco.

Can we do it for the current month that means without any selection it should show current month not present empcode.

[singbittoo]

you can simply change the tresesco's expression to : it should work

=Concat(DISTINCT {<Month ,EmpCode=P({1<Month={"$(=Month(AddMonths(today(),-1)))"}>})> - <Month ,EmpCode=P({1<Month={"$(=Month(today()))"}>})>} EmpCode, ',') , check for brackets and all ..

[singbittoo]

Hi Tresesco, what's the use of putting Month, in set analysis ? Concat(DISTINCT {<Month, <- this one

[singbittoo]

you can add three more rows like

4/4/2018	12
4/4/2018	6
4/4/2018	7

and write the above expression it will work fine

[tresesco]

Current month as in system month (month(today())), or latest month available in data?

[tresesco]

Try removing that part and see the effect on output in the sample app. If even that doesn't help understand, let me know. I am generally lazy explaining in text.

[Mark_Little]

Hi Lalit,

How about something in script like this.

Mark

[singbittoo]

yes the code doesn't work, is it equivalent to ignoring month selection ? if there is something else to it can you explain it will be helpful